SQL Agent Job not firing when scheduled

• thisted

  SSCrazy

  Points: 2131

  More actions

  June 9, 2014 at 12:02 pm

  #292157

  So, had an odd problem today. We have a job that runs quarterly to generate some reports. The job has 4 different schedules, each scheduled for the first day of a quarter, and scheduled to repeat every 12 months. The problem is, the Job did not fire on 6/1 like it was supposed to, and appears like it didn't fire on 3/1 either. Any insight?

  Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)

  Mar 29 2009 10:11:52

  Copyright (c) 1988-2008 Microsoft Corporation

  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)

  

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  June 10, 2014 at 4:18 pm

  #1720600

  silly questions:

  was there a maintenance outage or down time ?

  do you have the SQL Server errorlogs available ?

  does your job produce an output log file ?

  have you scanned the application and system event logs ?

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."