ERP/3.0/Developers Guide/Database Model/org.openbravo.model.scheduling/obsched triggers
This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
obsched_triggers
- Name:obsched_triggers
- Classname:OBSCHEDTriggers
This table contains the following columns:
Name | Nullable | Data Type | Description
|
Calendar_Name | Yes | VARCHAR (200) | Calendar name identifier. |
Description | Yes | VARCHAR (250) | A description is limited to 255 characters. |
END_Time | Yes | DECIMAL (13,0) | The time the process execution finished. |
JOB_Data | Yes | BLOB | Serialized job data for process execution. |
JOB_Group | No | VARCHAR (200) | Quartz job group identifier. |
JOB_Name | No | VARCHAR (200) | Quartz job name identifier. |
Misfire_Instr | Yes | DECIMAL (2,0) | Misfire instruction policy. By default smart policy is used and quartz takes care of choosing the correct policy. |
Next_Fire_Time | Yes | DECIMAL (13,0) | The next time a process will execute. |
Obsched_Triggers_ID | No | VARCHAR (32) | |
Prev_Fire_Time | Yes | DECIMAL (13,0) | Last time the trigger has been fired. |
Priority | Yes | DECIMAL (13,0) | The Priority indicates the importance of this request. |
Sched_Name | No | VARCHAR (120) | Quartz scheduler name. In non-clustered environment it's "NON-CLUSTERED".
In a clustered environment it usually matches the machine.name of the cluster instance. |
Start_Time | No | DECIMAL (13,0) | The time at which an item is due to, or did, start. |
Trigger_Group | No | VARCHAR (200) | Quartz trigger group identifier. |
Trigger_Name | No | VARCHAR (200) | Quartz trigger name identifier. |
Trigger_State | No | VARCHAR (16) | State of a quartz trigger. |
Trigger_Type | No | VARCHAR (8) | Type of trigger. Possible values: Blob, Calendar, Simprop, Simple, Cron |
Columns
Calendar_Name
- Physical column name: Calendar_Name
- Property Name: calendarName
- Reference: String
Description
- Physical column name: Description
- Property Name: description
- Reference: String
End Time
- Physical column name: END_Time
- Property Name: endTime
- Reference: Integer
JOB_Data
- Physical column name: JOB_Data
- Property Name: jOBData
- Reference: Binary
JOB_Group
- Physical column name: JOB_Group
- Property Name: jOBGroup
- Reference: String
JOB_Name
- Physical column name: JOB_Name
- Property Name: jOBName
- Reference: String
Misfire_Instr
- Physical column name: Misfire_Instr
- Property Name: misfireInstr
- Reference: Integer
Next Execution
- Physical column name: Next_Fire_Time
- Property Name: nextExecution
- Reference: Integer
Obsched_Triggers_ID
- Physical column name: Obsched_Triggers_ID
- Property Name: id
- Reference: ID
Prev_Fire_Time
- Physical column name: Prev_Fire_Time
- Property Name: prevFireTime
- Reference: Integer
Priority
- Physical column name: Priority
- Property Name: priority
- Reference: Integer
Sched_Name
- Physical column name: Sched_Name
- Property Name: schedName
- Reference: String
Start Time
- Physical column name: Start_Time
- Property Name: startTime
- Reference: Integer
Trigger_Group
- Physical column name: Trigger_Group
- Property Name: triggerGroup
- Reference: String
- This column is part of the table's identifier
Trigger_Name
- Physical column name: Trigger_Name
- Property Name: triggerName
- Reference: String
- This column is part of the table's identifier
Trigger_State
- Physical column name: Trigger_State
- Property Name: triggerState
- Reference: String
Trigger_Type
- Physical column name: Trigger_Type
- Property Name: triggerType
- Reference: String
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- OBSCHED_T_C_I Not Unique. Columns:
- SCHED_NAME
- CALENDAR_NAME
- OBSCHED_T_G_I Not Unique. Columns:
- SCHED_NAME
- TRIGGER_GROUP
- OBSCHED_T_J_I Not Unique. Columns:
- SCHED_NAME
- JOB_NAME
- JOB_GROUP
- OBSCHED_T_JG_I Not Unique. Columns:
- SCHED_NAME
- JOB_GROUP
- OBSCHED_T_N_G_STATE_I Not Unique. Columns:
- SCHED_NAME
- TRIGGER_GROUP
- TRIGGER_STATE
- OBSCHED_T_N_STATE_I Not Unique. Columns:
- SCHED_NAME
- TRIGGER_NAME
- TRIGGER_GROUP
- TRIGGER_STATE
- OBSCHED_T_NEXT_FIRE_TIME_I Not Unique. Columns:
- SCHED_NAME
- NEXT_FIRE_TIME
- OBSCHED_T_NFT_MISF_I Not Unique. Columns:
- SCHED_NAME
- MISFIRE_INSTR
- NEXT_FIRE_TIME
- OBSCHED_T_NFT_ST_I Not Unique. Columns:
- SCHED_NAME
- TRIGGER_STATE
- NEXT_FIRE_TIME
- OBSCHED_T_NFT_ST_MISF_GRP_I Not Unique. Columns:
- SCHED_NAME
- MISFIRE_INSTR
- NEXT_FIRE_TIME
- TRIGGER_GROUP
- TRIGGER_STATE
- OBSCHED_T_NFT_ST_MISF_I Not Unique. Columns:
- SCHED_NAME
- MISFIRE_INSTR
- NEXT_FIRE_TIME
- TRIGGER_STATE
- OBSCHED_T_STATE_I Not Unique. Columns:
- SCHED_NAME
- TRIGGER_STATE
![]() | Back to org.openbravo.model.scheduling |