Thursday, March 8, 2012

Call web service from sql server 2000 job

I would like to call a web service from a sql server 2000 s.proc/sql job, but if there is a better way please let me know.

I'm using Captaris Workflow to create and manipulate workflow processes. I have a sql job that will create some pdf's. I want to call the web service that creates a new process in a step from that sql job. I have read about doing this with extended s.procs, but I'm trying to find any possible solutions. Essentially, the web method I want to call will insert several records into sql so I know I can at least do that. I would still like to know if I can make a call to the web service from the sql job.

Thanks for any help.


Hi,

If you stored procedure is running as a SQL job, I think this might be the only way.

If it is only a stored procedure that is not called timely, I would suggest you call it from a method in your application. Pass the other information as parameter will be better.

No comments:

Post a Comment