Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-08 : 09:15:49
|
| srinivas writes "Hi, I am trying to send SMS messages through SQL server. For this I'm using XML interface to make a HTTP request to the remote server. The VBScript works fine when I run in the ASP page. So I've modified the same script to run as SQL server jobBut when I try to run the same as a job in SQL server it's not working. At the moment I'm using the VBScript like this...... Dim xmlDOMDocument Set xmlDOMDocument=CreateObject("MSXML2.DOMDocument") Then appending all the tags to the XML document Then creating a request Dim xmlRequest xmlRequest="<?xml version=""1.0"" encoding=""UTF-8""?>" & xmlDOMDocument.xml Making an http request like Set oHTTP=CreateObject("Microsoft.XMLHTTP") oHTTP.open "POST", httpAddress, False sending the request oHTTP.Send xmlRequest Set xmlDOMDocument=Nothing Set oHTTP=Nothing I've added the notification, to my email id, but that doesn't give me much information, why the job is failing. It simply says, JOB RUN: 'SendMSG' was run on 04/04/2004 at 2:59:17 p.m. DURATION: 0 hours, 0 minutes, 0 seconds STATUS: Failed MESSAGES:The job failed. The Job was invoked by User sa. The last step to run was step 1 (SendMSG). Can you please tell me what can go wrong here? But it's running fine when I run the sam thing as a ASP file with the Server.CreateObject... Regards, Srinivas Do I need to Provide any permission in the sql server for using createObject? I've given the role of SYS Admin to the user I'm using to perform the job.I'm using Sql server 2000 with SP3, and Windows 2K Pro" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 11:52:53
|
| Right click on the job, go to view job history. Click the check box to expand the details. What does the error say?Tara |
 |
|
|
|
|
|
|
|
SQL Server 2000 - Job