SCHEDULED_MESSAGE table

Edit online

The SCHEDULED_MESSAGE table stores information associated with a scheduled event that is provided by the scheduler. The scheduler is a component of IBM Verify Identity Governance that stores one-time or regularly scheduled events. These events are typically user requests that are made through the workflow engine or recurring reconciliation events.

Table 1. `SCHEDULED_MESSAGE` table
Column Name	Description	Data type
`SCHEDULED_TIME`	A value that represents the time of the scheduled event, which is the number of milliseconds since January 1, 1970, 00:00:00 Greenwich mean time.	Numeric
`SCHEDULED_MESSAGE_ID`^*	Unique ID for each scheduled event. Primary key.	Numeric
`MESSAGE`	A serialized object that represents the detailed information about the scheduled event.	Long Character
`SMALL_MESSAGE`¹	A small serialized object that represents the detailed information about the scheduled event.	Character (4000)
`SERVER`	The server that picks up the most recently scheduled event.	Character (255)
`CHECKPOINT_TIME`	A value that represents the last pickup time of the scheduled event, which is the number of milliseconds since January 1, 1970, 00:00:00 Greenwich mean time.	Numeric
`REFERENCE_ID`	Used only for scheduled workflow events, it is the workflow process ID from which the scheduled event is coming.	Numeric
`REFERENCE_ID2`	Used to store label and meta information about the scheduled message.	Numeric

^* Indicates the column is required and not null.

¹ Indicates the table is added in release 5.0.