Job schedules getting skipped

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  March 24, 2016 at 4:23 am

  #399908

  Hi All,

  Recently on Production Server, we observed some of the Job Schedules are getting skipped. I mean, jobs are not running as per scheduled. Can anyone tell what could be the reasons ??This is the first time we are seeing this in our environment.

  We are running SQL Server 2012 sp1. We ruled out SQL was running, SQL Agent was running fine also it wasn't long running jobs. Job is scheduled every day midnight at 12:00 am and it takes an 1 hour to complete. Very difficult to troubleshoot this.

  Can anyone provide their inputs on this?

  Thanks,

  Sam

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  March 24, 2016 at 4:27 am

  #1867348

  There's no chance somebody's accidentally entered an end date in the schedule, is there? It sounds silly but I've seen it happen.