Sql Server Job Did not Run


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
more ▼

asked Mar 22 '11 at 12:11 AM in Default

Mohan Kumar gravatar image

Mohan Kumar
204 16 20 21

(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

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.
more ▼

answered Mar 22 '11 at 06:35 AM

David Wimbush gravatar image

David Wimbush
4.7k 28 29 31

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....
Mar 22 '11 at 11:41 PM Mohan Kumar

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
Mar 22 '11 at 11:43 PM Mohan Kumar
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.
Mar 23 '11 at 12:23 AM David Wimbush
Yes, thats correct. But there are no events in the log file at 12:01 am (the job's scheduled time).
Mar 23 '11 at 02:09 AM Mohan Kumar
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.
Mar 23 '11 at 04:29 AM David Wimbush
(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Mar 22 '11 at 06:39 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.4k 14 20 44

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.
Mar 22 '11 at 11:44 PM Mohan Kumar
(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Mar 22 '11 at 11:45 PM

ThomasRushton gravatar image

ThomasRushton ♦
33.4k 14 20 44

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.
Mar 23 '11 at 12:24 AM Mohan Kumar
(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Mar 23 '11 at 05:51 AM

HelloFOFO gravatar image

106 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 22 '11 at 12:11 AM

Seen: 2121 times

Last Updated: Mar 22 '11 at 12:11 AM