Have you ever wondered what SQL Agent Jobs are most impactful in your SQL Server instance? Well, look no further.
Steps:
- Bring up DPA in your browser.
- Click on "Reports" in the upper right of the interface.
- Select the instance you are interested in within the Database Instance dropdown.
- Select "Top Programs" within the Report Type dropdown.
- Select Report Options button.
- Under the Programs to Display section, select the "User-Defined Programs" radio button.
- Click the add button. A search popup wizard will display.
- Enter "SQLAgent" in the search string area and click the search button.
- Highlight all or just the jobs you want to focus on and click OK.
- Click OK again.
- Click Display Report on the main dialogue view.
- And the results that even highlight pertinent steps.