March 17, 2008 at 4:25 am
Hi,
Well whenever my job gets fail i get the notification through the operator that my job failed and i get the following statistics.
JOB RUN: 'ABCD_TODO_REMINDER' was run on 3/16/2008 at 12:30:02 AM
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 153
(ABCD_TODO_REMINDER). The last step to run was step 1 (ABCD_TODO_REMINDER).
These are the statistics, i want to get complete error details in my email, as operator is configure to send email, i wonder if sql server 2005 provide this facilty to get complete error detail while sending notification, or i have to do something extra....if yes wat is that...
Highly appreciate any feedback
March 17, 2008 at 5:57 am
select * from msdb.dbo.sysjobhistory where message like '%failed%'
Ones that you need the full failure message on you could write a job to check this table every x minutes and do a sendmail job with the full error message as the message body for jobs that failed.
March 17, 2008 at 11:31 pm
Thansk Animal Magic for you quick response, well yup better to add another step on job failure and get the details from sysjobhistory table and then emailing it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply