ZSF_FCST_AUTO_PILOT_JOB_SCHED

Autopilot API inserts the next execution instance of each managed job into this table. Once Autopilot Job completes execution of a managed job, the corresponding execution instance in this table will be updated with the execution result. Also, the Autopilot API will be invoked to create the next execution instance of that managed job, which will be inserted into this table.

Details

• Schema: FUSION

• Object owner: ZSF

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZSF_FCST_AUTO_PILOT_JOB_S_PK	AUTO_PILOT_JOB_SCHED_ID, RETRY_COUNT

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AUTO_PILOT_JOB_SCHED_ID	NUMBER		18	Yes	Composite Primary Key. Retry count will be > 0 if the job supports retry.
RETRY_COUNT	NUMBER		5	Yes	Max retries will be controlled by the RETRY_COUNT in ZSF_FCST_AUTO_PILOT_JOB_DEFN.
MANAGED_JOB_CODE	VARCHAR2	100		Yes	Foreign Key from ZSF_FCST_AUTO_PILOT_JOB_DEFN
SCHEDULEDSTART	TIMESTAMP			Yes	Requested start time. This is the time Autopilot will trigger this job.
STATE	VARCHAR2	30		Yes	State / result of the schedule Job. Before the job is executed, this reflects the state of the schedule. Once the job is executed, this denotes the status of the ESS job.
PROCESSSTART	TIMESTAMP				Actual job start time
PROCESSEND	TIMESTAMP				Actual job end time
REQUESTID	NUMBER		18		ESS request id generated for this job
ERROR_MESSAGE	VARCHAR2	4000			Error message
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CONFLICT_ID	NUMBER		18	Yes	Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
USER_LAST_UPDATE_DATE	TIMESTAMP				Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).

Indexes

Index	Uniqueness	Tablespace	Columns
ZSF_FCST_JOB_SCHED_PK	Unique	Default	AUTO_PILOT_JOB_SCHED_ID, RETRY_COUNT