Derived from Quartz Scheduler DDL Stores data that define a trigger for use in UCM Delivery Schedules
| Column Name | Column Datatype | Column Null Option | Column Comment |
| trigger_uuid | byte(16) | not null | UUID for associated trigger |
| trigger_name | nvarcha(80) | with null | Name of trigger (UCM Delivery Schedule) |
| trigger_group | nvarcha(80) | with null | Calendar or CRON type |
| job_uuid | byte(16) | with null | UUID for associated Job |
| is_volatile | char(1) | with null | Flag for trigger activity |
| description | nvarcha(120) | with null | Description of Delivery Schedule |
| next_fire_time | integer | with null | GMT timestamp of next time trigger will execute |
| prev_fire_time | integer | with null | GMT timestamp of last time trigger executed |
| trigger_state | nvarcha(16) | with null | Trigger state flag |
| trigger_type | nvarcha(8) | with null | Trigger type flag |
| start_time | integer | with null | Time trigger becomes active |
| end_time | integer | with null | Time trigger becomes inactive |
| misfire_instr | smallint | with null | Not currently used |
| creation_user | nvarcha(64) | with null | Name of user who created the trigger |
| creation_date | integer | with null | GMT timestamp at creation of trigger |
| last_update_user | nvarcha(64) | with null | Name of user who last updated the trigger |
| last_update_date | integer | with null | GMT timestamp at last update of trigger |
Product Name: Unicenter Network and System Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| trigger_uuid |