SCHEDULED_MESSAGE table

The SCHEDULED_MESSAGE table stores information associated with a scheduled event provided by the scheduler. The scheduler is a component of IBM Security Identity Manager 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.

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_MESSAGE1	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.

Parent topic: Others