I want to start an SQL job when some updates have been made on my web-site
As others suggested, you can use sp_start_job to invoke a job.
But, I would suggest, whether you should really do it synchronously????
If you can convert these job invoke asynchronously, your performance would be good. You should think of inserting the values to a table and then process/invoke your job that scheduled every 1 minute(it depends on your requirement) that will pick those data and process. This way, your online (web) application performance would be good and your process rate would higher. Having said, the above suggestion is merely deending on your requirement.
Please mark this reply as answer if it solved your issue or vote as helpful if it helped.
[Blog]
No comments:
Post a Comment