Post reply

Run job from stored procedure

  • April 15, 2005 at 1:53 pm

    #165265

    Hi,

    I know how to start job from stored proc.

    But, could you helpm to find how to check in stored proc that job IS NOT running and start job after that.

    If job IS runing wait for 5sec and start the job.

    Thank you,

    Leonid

  • April 15, 2005 at 1:56 pm

    #553011

    See BOL about sp_help_job and sp_update_job.

  • April 15, 2005 at 2:21 pm

    #553018

    It should be very simple, but I am stuck

    How to chek status from sp_help_job inside of stored proc?

    Could you help with the line of code?

    Thank you

    Leonid

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

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