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!!!
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!!!