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