Post reply

Urgent help

  • April 17, 2007 at 10:43 am

    #116942

    How can i  return an error from a job to the stored procedure?

  • April 17, 2007 at 11:14 am

    #700970

    Here is where you need to start, BOL.  Lookup the tables sysjobs and sysjobhistory.  After your stored procedure starts the job, it needs to loop while waiting for the job to finish.  If it fails, you should be able to get the information out of sysjobhistory.

  • April 17, 2007 at 11:40 am

    #700978

    thanks it worked

  • April 17, 2007 at 11:44 am

    #700979

    Feels good when you figure something out on your own, doesn't it?  Now, if someone else has a similiar problem, you are in a position to help out.

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

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