Agent job did not run as per schedule

Question

Agent job did not run as per schedule

MANU-J.

SSC-Dedicated

Points: 31126
More actions
August 29, 2008 at 3:23 pm

#192209

Hi,
There is one sqlagent job which was schduled to run every week on Monday at 1:00 AM in night but since August second week Monday it didn't run as per schedule. Agent was started and sql server was available at tht time. Please tell me how to troubleshoot it.
SQL Server 2000 Standard Edition(SP3)
MJ

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Has it been disabled?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

Jack,

It was enabled during this time frame as job modified date says it was last modified on 29th May.

Since then it was never changed.

Thanks for the reply,

MJ

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Is it possibly still/already running?

Note that the only way to tell this for sure is to look at the "Status" column on the Jobs display. The History's and all other columns are updated after the fact. So if even your Job had been stuck on step 1 for a week or more, nothing else is updated to reflect it, only the Status column.

I have seen this a couple of times and it is very confusing...

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 4

Thanks for your replies guys. I checked and found that server is scheduled to be rebooted at same time when job starts so I think due to it job is not getting triggered up and there is no job history getting created for it.

I will change the job schedule time.

MJ

unclebiguns-494774 Valued Member Points: 54 More actions · Answer 5

unclebiguns-494774

Valued Member

Points: 54

August 30, 2008 at 5:36 pm

#865423

Why is the server scheduled to be rebooted weekly?

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 6

I think the previous DBA scheduled it on business request. I am trying to find the same with business owner too.

Thanks for asking,

MJ