I am using sql server 2000. My maintanance job is failing since last 1 month. That
job has 6 databases. I want to know at which database or databases it is failing. What is the best way to see that. My application log in windws event viewer says as under :
SQL Server Scheduled Job 'Optimizations Job-Sage Maint Plan1 'DSRS, DatelWMS,csmaster,tcr,wtenc,wtlive'' (0xCDCA3BB86E8E184FBAA781375CD3A87B) - Status: Failed - Invoked on: 2009-02-21 05:30:05 - Message: The job failed. The Job was invoked by Schedule 33 (Schedule 1). The last step to run was step 1 (Step 1).