Maintainance plane Job was failed for one database... Need to check how much time the job is running? Actually that is in restricted growth and we increased the maxsize to that file but
Need to know why that job failed and what are the steps we have what happend to that database?
asked Nov 22 '11 at 01:49 AM in Default
You can check the status of the failed job in View History option from the job's list . Same way in Maintenence Plan you can heck the view history option .
answered Nov 22 '11 at 02:25 AM
There are two possible places for errors, the SQL Server error log may have information about the failure. This is found under the Server Objects folder in Object Explorer.
You also may see errors in the SQL Agent error log. This is found under the SQL Agent folder in the Object Explorer.
Also, you can modify your jobs to provide an output file. This will contain a lot more detail if things go wrong to help you understand what happened. This is available on the Advanced paged of each Job Step.
answered Nov 22 '11 at 03:48 AM
Grant Fritchey ♦♦