September 12, 2007 at 8:21 am
I have a sql agent job scheduled to run every 15 minutes. (SQL 2005) This particular job does an import routine, but occasionally we have a need to run the job between schedules. I am thinking of adding a button to my application that will run a stored proc that executes the job. However, I am concerned that I will run into problems if this button is clicked at the same time that the job is executing on it's scheduled time. My question is, will Sql allow an instance of the job to be executed while sql agent is also executing the same job?
September 13, 2007 at 3:09 am
If you try to start a job which is already executing, nothing will happen. So you don't need to worry.
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply