How to know job when statred when completed and how much time it is running?
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?
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.