DPA Report on SQL Agent Jobs

Have you ever wondered what SQL Agent Jobs are most impactful in your SQL Server instance? Well, look no further.

Steps:

1. Bring up DPA in your browser.
2. Click on "Reports" in the upper right of the interface.
3. Select the instance you are interested in within the Database Instance dropdown.
4. Select "Top Programs" within the Report Type dropdown.
5. Select Report Options button.
6. Under the Programs to Display section, select the "User-Defined Programs" radio button.
7. Click the add button. A search popup wizard will display.
8. Enter "SQLAgent" in the search string area and click the search button.
   
9. Highlight all or just the jobs you want to focus on and click OK.
   
10. Click OK again.
11. Click Display Report on the main dialogue view.
    
12. And the results that even highlight pertinent steps.