Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

move verbose job failure notifications?

Status
Not open for further replies.

pandatime

Programmer
Jan 29, 2010
92
AU
Hi,

Is there a way to get the text from a "raiserror" in a proc to show in the job failure notification? That is, job step calls a proc, proc throws a raiserror, job fails, job sends failure email notification... but there's no raiserror in the email notification.

It's just:

JOB RUN: 'My job' was run on 3/11/2010 at 9:30:00 AM
DURATION: 1 hours, 42 minutes, 1 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 11 (Daily). The last step to run was step 4 (step 4).

I'd like a little more info.

Any suggestions welcome.

Thanks!!!
 
You can do it two ways that I can think of.

Output the RAISERROR message to a table or file.

Then have your email either query the table for the error message or attach the output file depending on which you choose to use.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top