I have a scheduled Check Database Intergrity maintenance plan in sql agent. Every time it completes, i get an email and it has always succeded until now. This time the status in the email is "Failed". I have tried to excute the job manually in management studio and again it failes. I now want to investigate and find out why and get issue resolved.
Where do i start. how can i get a detailed log report of the error. Below is email body am getting.
JOB RUN: 'Check Database Intergrity' was run on 10/7/2010 at 12:33:59 PM
DURATION: 0 hours, 0 minutes, 6 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by User MyDomain\MyDomainUserName. The last step to run was step 1 (Subplan_1).