Post reply

Missed SQL Jobs

  • April 3, 2006 at 12:34 pm

    #116858

    Is there a way to determine if a SQL job missed it's scheduled run during a server outage?  I kind of have an idea of how to maybe create something to do this using the sysjob tables and importing the event log, but it seems pretty involved and I wanted to bypass that if something already exists.

    Thanks

  • April 3, 2006 at 2:09 pm

    #630523

    You do need sysjobs and sysjobschedules to determine a scheduled time. You probably don't need to use Event Log, use sysjobhistory table to check if the job was executed for a particular job ID and scheduled timeframe. You may use run_status to see if the job was completed successfully.

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 1 (of 1 total)

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