April 14, 2014 at 10:20 pm
Hi,
I wanted to call a stored proc, on time basis ,
so i have made a job in sqlserver2008r2 and set it to run after 10 sec. it is running properly
but i fear that sometimes my stored proc will take more time to finish,that is more than 10 sec.
in that case , will sql agent job creats an other instence/process of the stored proc on scheduled time.
or it waits for running job till its completion, ( that is it skip its schedule) , and only calls the stored proc
after completion of the currect stored proc in the job?
any link will be help full?
yours sincerley
April 14, 2014 at 10:41 pm
Instead of asking, just set up a dummy job on a development system on a 5 minute schedule and a WAITFOR DELAY '00:10:05' in it. Then leave it 11 minutes and check the history to see what happens.
April 15, 2014 at 12:51 am
Sir, I will do it)
my expectaion was, that i will get some thing written from microsoft.
so please send any link, where i can get the theory.
and any tips regarding jobs ( specially i am using snapshot isolation in it) would be help full.
yours sincerly
April 15, 2014 at 8:02 am
If you have a job scheduled for 2pm, 4pm and 6pm, the job starts at 2pm is still running at 4pm and finishes at 4:15pm, the job wills start again at 6pm.
If the job is still running at the time it is scheduled to start again, SQL Agent won't start it. It also won't 'delay' that schedule. Instead the job will start at its next scheduled time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply