Microsoft SQL
Server agent monitoring and maintenance jobs
Microsoft SQL
Server
agent monitoring and maintenance jobsOn each database server, there are jobs that manage the database data and provide monitoring information.
There are two database servers and each has related jobs for the databases that reside there:
- Primary database server: contains thengdelivery_<plug-in> andngdiagnosticsdatabases.
- Logging database server: containsngdeliverylogdatabase.
The following tables summarize the jobs and what information that you can use to monitor the databases.
NDS Purge.Job
Purpose | Database server | Interval | Notes |
|---|---|---|---|
Archives and purges history data for the ngdelivery_<plug-in> and ngdiagnostic databases. | Primary | Nightly | — |
TaskHistoryUpdate
Purpose | Database server | Interval | Notes |
|---|---|---|---|
Updates the deliverytaskid and other data in the taskHistory table. | Logging | Every one minute | If this job stops, usage data will display incorrectly. |
LogRealTimeDataPurgeJob
Purpose | Database server | Interval | Notes |
|---|---|---|---|
Summarizes task history data in the TaskSummary table. | Logging | Nightly | If this job stops running, task history data is purged after 1 month. |
LogHistoryDataPurgeJob
Purpose | Database server | Interval | Notes |
|---|---|---|---|
Deletes real time data from the Message , Task , MessageLifeCycle , TaskLifeCycle , and AccessLog tables. Also deletes InboundEvent data older than 4 hours. | Logging | Every 4 hours | — |
TaskSummaryDataPurgeJob
Purpose | Database server | Interval | Notes |
|---|---|---|---|
Deletes task summary data that is older than 2 years.Default: DISABLED. | Logging | Manual | OnPremises Installations: Enable this job and change to 1500 the value of PURGE_TASKSUMMARY_THRESHOLD_IN_HOURS in the GLB_Config table. |