Search code examples
sql-serverssisssmssql-server-agentssms-2014

Finding the right SQL report

I know that I've used it before but I cannot find it now.

I have several SQL Server Agent jobs that run. Some of them fail, but the error messages in the History are not very helpful. I found a report that helped, but now I cannot remember where I found it exactly.

I know that I right-clicked => Reports => Standard Reports => All Execution?

I'm not sure about the last step or where the first step is supposed to be.

Can anyone help?

Solution

  • I guess that your SQL Agent Job runs SSIS package.

    To get detailed info use:

    SSMS -> Integration Services Catalog -> SSISDB -> RC -> Reports -> Standard Reports -> All Executions