Environment
Situation
Resolution
APPMANAGER V7.0.1 SCHEDULED TASKS
This document describes the SQL Scheduled tasks provided by AppManager for both the AppManager (QDB) Repository and the Control Center (CCDB) repositories. Optimal functioning of both databases is dependent on these scheduled tasks running correctly.
DOCUMENT VERSION: 2.0
DOCUMENT DATE: 25-SEP-2007
DOCUMENT AUTHOR: ANDY DORAN
NETIQ AMDC DAILY [QDB]
Stored Procedure: AMDC_task_daily
Schedule: Daily, at 1:30am
This task invokes the stored procedure AMDC_task_daily which in turn calls the stored procedure DeleteOldDiagArchiveData. This is used to remove data points from any job that collects diagnostic data (any job where the legend contains the phrase ?DiagData?). This should only affect jobs generated by the AppManager Diagnostic Console. When called by the AMDC daily task, any such diagnostic data is removed when it is more than 1 day old
NETIQ ARCHIVE EVENT [QDB]
Stored Procedure: Archive_Event
Schedule: Every 2 hours
This task invokes the stored procedure Archive_Event which in turn calls the stored procedure MoveArchiveEvent. This procedure will only continue if the preferences to archive events have been set. Assuming that this is the case, the procedure will then go on to process events according to the global settings. Affected events will be moved from the Event and EventDetail tables into the ArchiveEvent and ArchiveEventDetail tables, and the columns C1EventCount through C4EventCount in the Object tables updated accordingly.
NETIQ CHART CONSOLE BACKUP [QDB]
Stored Procedure: BackupBlob
Schedule: None
This task is disabled (has no schedule) by default. If enabled, it will make a backup of the Blob table (this table is used to store all charts). When this first executes, it will create a new table called blobBackup. Subsequent calls to the stored procedure, or executions of the task, will drop and re-create this table.
NETIQ CHART CONSOLE RESTORE [QDB]
Stored Procedure: RestoreBlob
Schedule: None
This task is disabled (has no schedule) by default. If enabled, it works in conjunction with the ?NetIQ Chart Console Backup? task and will restore the Blob table using the blobBACKUP table. This process involves removing all data that currently exists in the Blob table (used for charts in the Chart Console)
NETIQ DAILY [QDB]
Stored Procedure: task_daily
Schedule: Daily, at 1:00am
This task invokes the stored procedure task_daily. The procedure will physically remove Objects, Jobs, Actions and Events that have been marked for delete (a status of 0x08000000, except in the Event table where the status used is 0x80000000). Related tables are also affected by this process ? such as JobObject, ActionBaseScript, ActionParentProperty, ActionTmpl, ParentJobScript, ParentJobProperty and ViewHierarchy. Data from Control Center related tables in the QDB are also affected by the daily task including tables relating to Custom Properties that have been set via Control Center. Finally, housekeeping tasks such as table re-indexing and updating statistics are performed by this procedure.
NETIQ DYNAMIC VIEW [QDB]
Stored Procedure: UpholdPolicy
Schedule: Every 1 minute
This task invokes the stored procedure UpholdPolicy using the parameter ?DV? for ?Dynamic Views?. If a discovery is taking place, no action is taken by this procedure. With the ?DV? option, the first action is to invoke the procedure UpholdDynamicPolicy. This is a complex procedure, but the basic premise is that it will ensure that the relevant information is shown in dynamic views if any exist. Once this has been done, the procedure MPex_RestartJob is called. This procedure ensures that any jobs affected by parameter overrides are restarted with their override values if the corresponding custom property value has changed.
NETIQ HOURLY [QDB]
Stored Procedure: task_hourly
Schedule: Every 2 hours
This task invokes the stored procedure task_hourly which performs some housekeeping (UPDATE STATISTICS) on various tables. The task also ensures that the Job Count on objects that have had jobs removed is reset to zero. Additionally, tables related to overrides and custom properties from Control Center are cleaned by this procedure (for example, where values have been removed ? marked for delete - in Control Center, they are processed here).
NETIQ LICENSE AUDIT [QDB]
Stored Procedure: LicenseAudit
Schedule: Every 3 months on the 1st of the month
This task invokes the LicenseAudit stored procedure which checks the installed license keys against the information in the AppManager TreeView. If there is a discrepancy, an event is raised in the console to remind the administrator that more licenses may be required. The same procedure is used in the AppManager CompLic report.
NETIQ MINUTELY [QDB]
Stored Procedure: task_minutely
Schedule: Every 5 minutes
This task invokes the stored procedure task_minutely which in turn executes the procedure RestartErroredJobs to locate any jobs that have the error status set and ensure they get restarted. It then examines the DataRejected table to see if there are any data points stored there that could be moved into the Data tables. If so, these rows are moved. New in V7.0.1 is the ability to restart policy jobs that have stopped. This is enabled or disabled via a Global Preference (the GlobalPref table ? the preference name is ?Restart_Stopped_PolicyJobs?). If the value of this global preference is 0 then stopped policy jobs are not restarted, if the value is 1 they will be restarted *providing they were not stopped manually through Control Center*. This feature is available in V7.0, but has no concept of a policy job being stopped via Control Center so it is recommended not to enable it unless using V7.0.1.
NETIQ POLICY FOR CCMP [QDB]
Stored Procedure: CC_UpholdCCMP
Schedule: Every minute
This task invokes the stored procedure CC_UpholdCCMP which ensure that any monitoring policy defined in Control Center is applied within the QDB.
NETIQ PURGE ARCHIVED EVENT [QDB]
Stored Procedure: PurgeArchivedEvent
Schedule: Daily, at 2:00am
This scheduled task invokes the stored procedure PurgeArchivedEvent, which will take no action unless the archiving of events is enabled. Assuming this is the case, this procedure will clean out events from the ArchiveEvent tables based on the selection criteria defined in the Operator Console.
NETIQ PURGEDATA [QDB]
Stored Procedure: PurgeAllData
Schedule: Every 6 hours
This scheduled task invokes the stored procedure PurgeAllData. This procedure deletes data points from the Data table based on the retention settings for data (the default is to retain data for 8 days, but this can be altered globally and for each individual data stream). The global preferences PurgeAllDataBatchSize and PurgeDataFromToday are used in this procedure. The batch size default is 10,000 meaning that only 10,000 rows maximum will be affected. The second setting determines whether the ?delete from? date is ?now? or from the timestamp of the most recent data point in each individual data stream. Depending on what these preferences are set to, not all data will be removed at any iteration of this task.
NETIQ RULE BASED DYNAMIC VIEW [QDB]
Stored Procedure: UpholdRuleBasedDynamicView
Schedule: Every minute
This scheduled task invokes the stored procedure UpholdRuleBasedDynamicView which ensures that servers are correctly represented in rule based dynamic views. Note that a rule based dynamic view generated as a result of a Control Center rule based Management Group are not displayed in the Operator Console.
NETIQ UPDATE MG SERVER MEMBERSHIP [QDB]
Stored Procedure: CC_UpdateMGServerMembership
Schedule: Every Minute
This scheduled task invokes the stored procedure CC_UpdateMGServerMembership which ensures that the various CC based tables in the QDB are updated so that the information can be moved into the CCDB for display in the Control Center Console.
NETIQ VSG MONITOR MODTIME UPDATE (RUNS CONTINUOUSLY) [QDB]
Stored Procedure: CC_UpdateVSGModTime
Schedule: Every minute
This scheduled task invokes the stored procedure CC_UpdateVSGModTime which although scheduled to run every minute has an infinite loop such that if no error is encountered, it will in effect run every 15 seconds. It is responsible for updating the modification time in various tables relating to servers and views. The information is then used by Control Center to determine if the CCDB needs to be updated.
NETIQ WEEKLY [QDB]
Stored Procedure: task_weekly
Schedule: Every Sunday at 3:00am
This scheduled task invokes the stored procedure task_weekly. The procedure reindexes some tables ? such as Data, Event and TextPt. If data aggregation is enabled, it will then process aggregation data (i.e. data in the ArchiveData table will be aggregated and moved to the Arc* tables). Aggregation is processed each week for Hourly and Daily averages but only on the first Sunday in the month for Monthly averages. After processing aggregation, other housekeeping relating to policy jobs is undertaken.
NETIQ CC DAILY TASK
Stored Procedure: TaskDaily
Schedule: Daily at Midnight
This scheduled task invokes the stored procedure TaskDaily which performs housekeeping on Event, Job and Computer tables (i.e. physically removes items marked for delete).
NETIQ CC HALF-HOURLY TASK
Stored Procedure: TaskHalfHourly
Schedule: Every 30 minutes
This scheduled task invokes the stored procedure TaskHalfHourly which maintains the Queue table. This table is used by the CQS service for tasks submitted via the Control Center console (such as creating new jobs, or closing events).
NETIQ CC HOURLY TASK
Stored Procedure: TaskHourly
Schedule: Every hour
This scheduled task invokes the procedure TaskHourly which maintains a number of background tables including the ArchiveQueue table and the Object table (which holds information about the Management Groups and views within those groups). Custom Properties and security configuration information also are processed by this procedure.
NETIQ CC MANAGE SQL JOBS
Stored procedure: ManageSQLJobs
UpholdWildcardMembers
Schedule: Every minute
This schedule task invokes the stored procedures ManageSQLJobs followed by UpholdWildcardmember. The first step is used to maintain the SQL jobs for each datasource (registered QDB). These jobs are not used in V7 as the NQSYNCQDB process takes over the process, but the jobs still get created for backwards compatability in Control Center V7.0, but are no longer created in Control Center V7.0.1. UpholdWildcardMember is used to ensure that Management Groups based on either a view or server group from ?All repositories? (ie the Master Management Group) are kept up to date.
NETIQ CC SMV HOURLY TASK
Stored Procedure: SMVTaskHourly
Schedule: Every hour
This scheduled task invokes the stored procedure SMVTaskHourly which maintains various tables relating to Service Map Views (deleting information that has been marked for removal).
NETIQ CC UPGRADE QDB 6.0 TO 7.0 THROUGH LINKED SERVERS IN CCDB
Stored Procedure: SqlScript2LinkedQDB_Upgrade60ForCCDB65
Schedule: None
This scheduled task is used to upgrade existing V6 QDBs. See the user documentation for more information.
Additional Information