Post reply

DTS - howto check a scheduled job current occurence

  • February 14, 2006 at 8:37 am

    #620706

    You can use sysjobhistory table in msdb, it will tell you the status, the run time and the duration of the job it runs previous time.

  • February 15, 2006 at 12:40 pm

    #621173

    Run the first task 5 times on one job (00:00 to 16:01)

    Run the last task on 1 job with 2 steps (20:00 once a day)

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

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