April 17, 2007 at 10:43 am
How can i return an error from a job to the stored procedure?
April 17, 2007 at 11:14 am
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
thanks it worked
April 17, 2007 at 11:44 am
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