October 16, 2009 at 1:26 am
Hi All,
I have a job scheduled to start at 5:00 PM everyday. Yesterday this job didn't start. I looked in the Job Activity Monitor view and found that the last Run time = 2009/10/14 5:00 PM, Outcome = Successful. Next Run 2009/10/16 05:00 PM. Somehow it's just skipped a day!? :ermm:
This is the first time this has happened, can anyone tell my why something like this would happen?
Many thanks
William
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
October 16, 2009 at 1:30 am
WilliamBendall (10/16/2009)
Hi All,I have a job scheduled to start at 5:00 PM everyday. Yesterday this job didn't start. I looked in the Job Activity Monitor view and found that the last Run time = 2009/10/14 5:00 PM, Outcome = Successful. Next Run 2009/10/16 05:00 PM. Somehow it's just skipped a day!? :ermm:
This is the first time this has happened, can anyone tell my why something like this would happen?
Many thanks
William
No idea unless it was either disabled and re-enabled or the schedule has changed.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 16, 2009 at 1:41 am
Is there some sort of log I can check to see if the SQL Server Agent was actually up and running at that time?
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
October 16, 2009 at 1:45 am
yep you can look at the sql agent log, under sql server agent, there is error logs, look in there.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 16, 2009 at 1:48 am
Thanks I got there. It seems someone bounced the server while the package was executing.... now just to find out who so I can kill them 😉
----------------------------------------------------------------------------------------------
Struggling to find the question?
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply