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.