I installed cartridge for foglight SQL server to monitor SQL server database... and there is job consist of three steps and the third step is hanging for 12 hours. and there is alarm in foglight which show that there is failure job.. but it didn't give me any details about why happened this?
it show that there is job failure only without any details
please let me know from where know the cause of job failure?
SQL Agent Job details are available in the Services -> SQL Agent Jobs drilldown. Clicking on a job, will show the job details, including the error message that caused the failure. See the screenshot below for information. If you have any other questions, please let me know.