February 17, 2010 at 8:37 am
I have a SQL Agent job that runs daily. It usually takes about 10 minutes to run but a client gave me a very large load to process without telling me. So this time it's going to take about 36 hours. My question is this: With the job scheduled to run tomorrow morning and the job already running, will SQL Agent try to fire off a 2nd instance of the job?
If it will I need to know if I can safely disable a running job without the job stopping.
February 17, 2010 at 8:42 am
I figured out what I needed to do to feel safe about this. Disable the schedule rather than the job itself. Simple.
February 17, 2010 at 9:11 am
If the job is already running it won't start a second instance.
I think the last time it would execute a second instance was back in SQL 6.5.. So no problem..
CEWII
February 17, 2010 at 12:41 pm
Good to know the answer even with a solution in place. Thanks so much.
February 17, 2010 at 1:41 pm
As Elliott W stated, it will not start a second instance of the job.
It will register a message in sqlagent.out that the job was already running. 😎
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply