Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » SQL Agent skipping job runs?
Add to briefcase
20 posts, Page 1 of 2
12»»

SQL Agent skipping job runs? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Wesley Brown
Posted Monday, January 05, 2009 10:10 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379
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
DBA in Unit 7
Posted Monday, January 05, 2009 10:20 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 12:34 PM
Points: 195, Visits: 1,057
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
Wesley Brown
Posted Monday, January 05, 2009 10:44 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379
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
Paresh Prajapati
Posted Monday, January 05, 2009 10:24 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 31, 2012 6:08 AM
Points: 322, Visits: 459
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
Ignacio A. Salom Rangel
Posted Tuesday, January 06, 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: Yesterday @ 9:36 AM
Points: 3,051, Visits: 1,357
Did you find out what the problem was?



My blog
Post #630377
Wesley Brown
Posted Tuesday, January 06, 2009 7:13 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379
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
Vee
Posted Tuesday, January 06, 2009 7:44 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Today @ 5:17 AM
Points: 409, Visits: 409
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
george sibbald
Posted Tuesday, January 06, 2009 7:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 5,269, Visits: 11,208
any chance sql agent just wasn't running at the time?

---------------------------------------------------------------------
Post #630590
Wesley Brown
Posted Tuesday, January 06, 2009 8:35 AM


SSChasing Mays

SSChasing Mays

Group: Moderators
Last Login: Tuesday, May 07, 2013 3:54 PM
Points: 608, Visits: 379
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
Jason Shadonix
Posted Tuesday, January 06, 2009 8:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 4:06 PM
Points: 1,409, Visits: 2,027
If you right-click on the job in SSMS, and hit view history, does it come back with anything at all?

Jason Shadonix
MCTS, SQL 2005
Post #630653
« Prev Topic | Next Topic »

Add to briefcase
20 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.