Using Schedule Manager › Override Schedule Manager › System State Manager Resource Tables

System State Manager Resource Tables

Schedule Manager RESET processing looks for a SCHEDMODE column in a resource table. If one is present, then Schedule Manager looks for a value of INACTIVE. For any resource having a value of INACTIVE in its SCHEDMODE column, Schedule Manager bypasses any updates to its DESIRED_STATE column during RESET processing.

To use this feature, manually add a SCHEDMODE column to resource tables if one is not already present. The BASIC and STC model tables available in the RDF Table Editor (OPSVIEW primary option 2.6) contain a SCHEDMODE column with a default value of ACTIVE.

This feature makes it possible for the user to override the scheduled state of a resource through a single SQL statement similar to the following example:

UPDATE table SET SCHEDMODE='INACTIVE' WHERE NAME='resource'

Likewise, the user can return control of the resource to Schedule Manager through a single SQL statement similar to the following example:

UPDATE table SET SCHEDMODE='ACTIVE' WHERE NAME='resource'

Such SQL statements can be inserted into user-coded CA OPS/MVS rules to override the scheduled state of selected resources while allowing Schedule Manager to maintain the usual scheduled states of other system resources. For example, the user can code emergency START or STOP started task command (CMD) rules that set the SCHEDMODE of the resource to INACTIVE and the DESIRED_STATE of the resource to UP or DOWN.