Defines a task for the scheduler to pick up
| Column Name | Column Datatype | Column Null Option | Column Comment |
| task_id | varchar(50) | not null | The unique task id, which identifies the task |
| name | nvarchar(64) | with null | The descriptive name of the task |
| comment | nvarchar(64) | with null | Any specific comments for additional data for this task |
| day_of_month | integer | with null | Task execution day of month |
| day_of_week | integer | with null | Task execution day of week |
| hour | integer | with null | The hour which the task will be executed |
| minute | integer | with null | The minute which the task will be executed |
| month | integer | with null | The month which the task will be executed |
| status | integer | with null | The status of the task, 1 - ACTIVE, 0 - INACTIVE |
| task_to_exec | nvarchar(64) | with null | The action, that need to be done as part of this task execution |
| type | varchar(20) | with null | Specifies the type of the task |
| year | integer | with null | The year which the task will be executed |
| start_date | date | with null | The start date, if this is a repetitive task |
| end_date | date | with null | The end date, if this is a repeative task |
| requestor | nvarchar(64) | not null | Specifies which component made the request for this task |
| runtime_component_id | varchar(50) | with null | The runtime component handle which is responsible for the task |
| action_type | integer | with null | Inidicate the type of the action |
| data1 | nvarchar(1024) | with null | For external integration/implementation |
| data2 | nvarchar(64) | with null | For external integration/implementation |
| data3 | nvarchar(128) | with null | For external integration/implementation |
| data4 | nvarchar(256) | with null | For external integration/implemenatation |
| data5 | nvarchar(256) | with null | For external integration/implemenatation |
| interval | integer | with null | Interval between one execution and the next |
| dst_id | varchar(20) | with null | The handle to dst object for this task |
| description | nvarchar(128) | with null | The description of the task |
| action_description | nvarchar(128) | with null | The detailed description of this action |
| created_date | date | with null | The time recorded for when the task is created |
| last_exec_date | date | with null | The last executed time for this lask |
| missed_action | nvarchar(64) | with null | The action, specifies what need to be done, if the task is missed |
| user_id | nvarchar(100) | with null | The userid , who created this task |
| modified_date | date | with null | The modified date for this task |
| guinode_id | varchar(50) | with null | Hand to guinode if a guinode is to be invoked as a result of this task |
| time_zone_code | varchar(64) | with null | Time zone code is the code for a particular time zone, Eg- EST, PST etc |
| tenant_id | varchar(50) | with null | Handle to the tenant object if the task is organization based |
Product Name: Unicenter Service Management
Table Type: Table