question

Mohan Kumar avatar image
Mohan Kumar asked

Sql Server Job Did not Run

Hi We have a Scheduled Job which runs daily at 12:01 am. But on Friday it did not run. I checked the Sql Server Logs, but could not find anything related. In the event viewer I could find "The browser service has failed to retrieve the backup list too many times on transport \Device\NetBT_Tcpip_{..........}. The backup browser is stopping." at 11:58:33 pm the previous night. Kindly let me know what could be the reasons: I'm sure there was no server restart & services are enabled to run automatically. Rgds Mohan Kumar VS
sql-server-2005sqlserver
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
A few possibilities: 1. Is the job enabled? 2. Is the job's schedule enabled? 3. Have you checked the SQL Agent log to ensure the service was actually running at that time? (You say you're sure but you don't say how you're sure.) 4. Did your clocks go back or forward around that time? That can mess things up.
6 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks. 1. The job is enabled. 2. The job is also scheduled. 3. Kindly let me know how to ensure that the service was actually running at that time. 4. There were no clock resetting....
0 Likes 0 ·
I checked the service using Sql Server Agent log Sql Server Agent Error Log: Date 3/18/2011 6:48:36 AM Log SQL Agent (Archive #4 - 3/19/2011 6:45:00 AM) Message [129] SQLSERVERAGENT starting under Windows NT service control
0 Likes 0 ·
So that confirms the SQLAgent service was started at 06:45 but look further back in the log. Every time the service starts it starts a new 'Current' log and archives the existing log, so you want to start with the archive that starts at 06:45 on the 17th and scan forwards for 24 hours.
0 Likes 0 ·
Yes, thats correct. But there are no events in the log file at 12:01 am (the job's scheduled time).
0 Likes 0 ·
Jobs running aren't in the error log. Only the startup and stopping of the service and exceptional events like errors. I meant that you need to look through the error log from the restart on the 17th to the restart on the 18th and make sure there's no sign that the service was stopped at 12:01 on the 17th.
0 Likes 0 ·
Show more comments
ThomasRushton avatar image
ThomasRushton answered
Has the job run successfully since then? Have you rebooted the server recently? Has the infrastructure changed recently? Does http://support.microsoft.com/kb/135404 fit / help?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yes, the job is running successfully after that particular day. The server re-starts everyday at 06:45 am... The job is scheduled at 12:01 am. The infrastructure didn't change recently.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
What other services are running on this box? Is it a domain controller? IIS? File server? Print server? Did anything else have trouble at the same time?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It is a database server. It is not a domain controller. I checked System, Security & Application logs also. Couldn't find any problem at that time.
0 Likes 0 ·
HelloFOFO avatar image
HelloFOFO answered
How long will the job last for? Maybe its still running on 3/18/2011 00:01, check the run history of 3/17/2011.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.