System Tables - ST_TASK

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Tables and Forms > System Tables (ST) >

System Tables - ST_TASK

The ST_TASK table maintains information related to Tasks that the automated tools within Enterprise (EIA and EDP) complete.

 

ST_TASK.TASK_ID

Integer identifying task

ST_TASK.JOB_ID

Integer job identifier assigned by system

ST_TASK.TASK_TYPE

System identifier for type of task completed by Enterprise EDP or EIA

ST_TASK.CREATED_DATE

Date and time task was created

ST_TASK.STUCK_DATE

Date and time when Enterprise task failed to complete.
Reference Enterprise Workflow Log for additional details.

ST_TASK.COMPLETED_DATE

Date and time task was completed

ST_TASK.RESERVATION_ID

Integer identifying task reservation

ST_TASK.RESERVATION_EXPIRATION

Date and time when attempts to complete task expired

ST_TASK.RESERVER_NODE

Server where database server is setup

 

Each task in DT_TASK corresponds with a record in the ST_TASK table. If a task gets stuck due to an error, the ST_TASK.STUCK_DATE is set to the date/time that the task became stuck. If the error has been resolved and you want to reprocess the task, clear the ST_TASK.STUCK_DATE and the task will be processed again. Note that ST_TASK.RESERVATION_ID and ST_TASK.RESERVATION_EXPIRATION cannot be null or the task will not be processed again. Do not delete the task or set ST_TASK.RESERVATION_ID or ST_TASK.RESERVATION_EXPIRATION to null or the task list in Enterprise will show the status as In Progress, although nothing will happen.

 

To cancel tasks, set ST_TASK.STUCK_DATE to the current time for any task where ST_TASK.STUCK_DATE, ST_TASK.COMPLETED_DATE, ST_TASK.RESERVATION_ID, ST_TASK.RESERVATION_EXPIRATION are null. This will result in the task not being performed when the workflow processes waiting tasks.

 

Warning:

If ST_TASK.RESERVATION_ID is not null and ST_TASK.RESERVATION_EXPIRATION is set to a time in the future or recently passed, do not alter ST_TASK.COMPLETED_DATE or ST_TASK.STUCK_DATE as this represents a task in progress.

Do not delete the task or set ST_TASK.RESERVATION_ID or ST_TASK.RESERVATION_EXPIRATION to null. The task will not be processed, even if ST_TASK.STUCK_DATE is cleared. Doing so will cause the task list in Enterprise to show the status as In Progress, although nothing will happen.