2

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?

Lukasz Szozda
  • 162,964
  • 23
  • 234
  • 275
Mike
  • 1,853
  • 3
  • 45
  • 75
  • Maybe SSMS -> Integration Services Catalog -> SSISDB -> Reports -> Standard Reports-> All Executions? – Lukasz Szozda Aug 23 '17 at 18:57
  • 1
    @lad2025 That was it!! I've been searching for almost an hour and couldn't remember where it was. Thanks! Put that in an answer and I'll mark it done! – Mike Aug 23 '17 at 19:08

1 Answers1

3

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

Lukasz Szozda
  • 162,964
  • 23
  • 234
  • 275