The following jobs require the SQL Server Agent to be running on the Database Server computer hosting the Aegis database.
Uses stored procedures to populate the reporting tables in the Aegis database on an hourly basis, starting one hour after Aegis initiates the first work item. If you run reports during the hour between jobs, the reports display data from the most recent instance of the job. If you run any reports in Reporting Center during the hour after the first work item, the reports will appear empty. If you require the most recent data in your reports, you can run the job manually. For more information about running the job manually, see Section 3.4.2, Starting a Job Manually.
Removes unused resources from the Resource Management database according to the specified retention times. The job optionally hides computers that are not currently sending data to Aegis. For more information about retention time for resources and hiding inactive computers, see the Help for Global Administrator Settings on the Options window in the Configuration Console.
Removes events, work items, and work item data from the Aegis database according to the specified retention times. The job removes unused events as well as events that are associated with work items. For more information about retention time settings for events and work items, see the Help for Global Administrator Settings on the Options window in the Configuration Console.
You can check the status of the SQL Server Agent at any time and, if necessary, start it manually.
To check the status of the SQL Server Agent:
Log on to the Database Server computer with an Administrator account.
Start Microsoft SQL Server Management Studio.
In the left pane, verify the SQL Server Agent is running.
If the SQL Server Agent is not running, right-click SQL Server Agent, and then click Start.
Click Yes.
On the File menu, click Exit.
The Capture New Report Data job runs hourly. If you want to populate the reporting tables before the regularly scheduled job, you can run it manually.
To run a job manually:
Log on to the Database Server computer with an Administrator account.
Start Microsoft SQL Server Management Studio.
In the left pane, expand SQL Server Agent > Jobs.
Right-click the job you want to start, and then click Start Job at Step.
On the Start Jobs window, review any messages.
If you receive an error message, in the Message field, click the link to see the details.
On the Start Jobs window, click Close.
On the File menu, click Exit.