Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Agent skipping job runs? Expand / Collapse
Author
Message
Posted Monday, January 5, 2009 10:10 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
Hello all,

I've got a weird one. It appears that I have had the SQL Agent just skip running a scheduled job task. No failure no job stuck executing just flat skipped it.

I did ask the mighty google but didn't see anything that resembled the problem.

Has anyone else had an issue with SQL 2005 skipping jobs like this?

Thanks,
Wes


http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #629955
Posted Monday, January 5, 2009 10:20 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 20, 2014 11:18 AM
Points: 196, Visits: 1,088
I've had this once and not figured out why.

Things you might want to check: Job enabled? Job schedule enabled? Job schedule starting time and ending time; windows time service, task scheduler service..
Post #629964
Posted Monday, January 5, 2009 10:44 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
Yeah,

I walked through all of it and so did someone else just to make sure I didn't miss something.
I hate writing a monitor for all the jobs on all the servers because they may not execute period.


http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #629986
Posted Monday, January 5, 2009 10:24 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 7:41 AM
Points: 323, Visits: 464
Wesley Brown (1/5/2009)
Hello all,

I've got a weird one. It appears that I have had the SQL Agent just skip running a scheduled job task. No failure no job stuck executing just flat skipped it.

I did ask the mighty google but didn't see anything that resembled the problem.

Has anyone else had an issue with SQL 2005 skipping jobs like this?

Thanks,
Wes


Please check SQL job owner has a access on that step code or not?


_____________________________________________________________________________________________________________
Paresh Prajapati
+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj
Post #630309
Posted Tuesday, January 6, 2009 2:14 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
Did you find out what the problem was?




My blog
Post #630377
Posted Tuesday, January 6, 2009 7:13 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
No not yet.

This job has run successfully except for the one day it skipped. It ran successfully today at its normal time. We can't find any reason for it to have skipped a run, the previous run was successful and in its normal run time.


http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #630544
Posted Tuesday, January 6, 2009 7:44 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 7, 2013 9:29 AM
Points: 409, Visits: 421
I think your sql agent cache is not in sync with msdb database. You can check this by running

xp_sqlagent_notify 'D', null, Null, null, null.

This will dump what is there in the sql memory for jobs. if your job is not listed then it will not run. Propably in that case you need to restart the sql agent.

After running the above query please look into agent error log it would have dumped what is there in sql server agent cache.

Post #630582
Posted Tuesday, January 6, 2009 7:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:21 AM
Points: 5,886, Visits: 13,042
any chance sql agent just wasn't running at the time?

---------------------------------------------------------------------

Post #630590
Posted Tuesday, January 6, 2009 8:35 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Wednesday, July 23, 2014 1:21 PM
Points: 609, Visits: 407
The job hasn't be modified since it was installed.

SQL Agent was running the whole time. We get alerts immediately if the agent is down from our nagios box.

We have had problems on other boxes where the job would hang on sending notification but nothing like this.

Cheers,
Wes


http://www.sqlserverio.com
http://www.cactuss.org
http://www.salssa.org
Post #630634
Posted Tuesday, January 6, 2009 8:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:18 AM
Points: 1,533, Visits: 2,259
If you right-click on the job in SSMS, and hit view history, does it come back with anything at all?

The Redneck DBA
Post #630653
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse