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
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.
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....
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
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.
Yes, thats correct. But there are no events in the log file at 12:01 am (the job's scheduled time).
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.
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?
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.
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?
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.
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.
