Post reply

DTS - howto check a scheduled job current occurence

  • February 10, 2006 at 10:56 am

    #365076

    Is there a way to check a job occurence from within the stored procedure that is scheduled to run every 1 day, every 4 hours ? I want to run another process when job executes the store procedure for the last time i.e. 6th time in 24 hrs.Thank you.

  • February 13, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • 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 4 posts - 1 through 3 (of 3 total)

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