Scheduling Database Maintenance Jobs in SQL Server Enterprise and Standard Edition
After installation, maintenance jobs are set up in the SQL Server. These jobs are by default disabled to avoid that production data is accidentally deleted. Delete maintenance is performed by a number of stored procedures with the prefix .tnmt.
It is recommended to use the provided Jobs for the ToolsNet installation:
Job | Purpose | Default values |
|---|---|---|
| All results, graphs and events older than specified number of days to keep will be deleted. The deletion is done in six steps with the possibility to set different values for each step. The default values are the same for all steps 1) Archive Check 2) Graph maintenance 3) Result maintenance 4) Event maintenance 5) MaintenanceLog 6) Program And Unit maintenance 7) History Maintenance 8) Tools Maintenance | Days to keep = 100, Bulksize = 5000 (rows/transaction)Schedule is every day at 01:00
Job is disabled |
| A job to delete all unbound graphs, i.e. traces without a result that have been sent to ToolsNet. | Days to keep = 1 BulkSize = 5000 Schedule everyday at 23:00 Job is enabled. |
| Rebuilds the indexes physically on the hard drives. Scheduled to run once a week. Makes all transactions and searches faster. | No settings to change. Job is enabled. Scheduled every Sunday at 03:00 |
| Reorganizes the indexes. Scheduled to run once a day. Makes all transactions and searches faster. | No settings to change.Job is enabled. Scheduled every day, but Sundays, at 03:00 |
Select Start , and then select All Programs.
Select Microsoft SQL Server, and then select SQL Server Management Studio.
On the SQL Server Management Studio dialog box, expand SQL Server Agent, and then expand Jobs.
In the Jobs folder, select a Job to configure the Job settings.
In the Select a page list, select Schedules.
Select the job in the Schedule list, and then select Edit.
In the Job Schedule Properties window, define the schedule as desired.
To make the job run from now on, select the Enabled check box.
Select OK.
