Post reply

Schedule a job ro run at specific time from last success run

  • October 9, 2015 at 8:36 am

    #321434

    Hi all,

    I have a job that runs twice a day, sometimes it fails due to some bad files received. I will like to schedule another job to check the status of the last failed job but only execute it if the job has failed and it can only run after 30 minutes from the last failed execution. Any thoughts and or comments will be helpful.

    Thanks,

  • October 9, 2015 at 8:48 am

    #1832566

    Does it have to run exactly 30 minutes after execution or can it run straight after execution?

    One thing would be to add in a secondary job and on failure of the primary job trigger the secondary.

    The first step in the secondary is a WAITFOR DELAY command set to 30 minutes, then the next steps would run whatever you need to run.

  • October 9, 2015 at 9:02 am

    #1832572

    Thank you for the response. The job must run 30 minutes minimum after the job last. Run. I will add the additional steps. You made a good point in the addition of the on failure steps. I was concentrating too much on checking for failure via a script.

    Thanks.

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

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