PSM_JobQueueCurrentView (ver9.0.0)

ActiveFlag

Number(3)

[From PSM_JobQueueCurrentView] If the job is active.

CreationTimeStamp

Timestamp(6)

[From PSM_JobQueueCurrentView] Date and time the job was created.

DownloadFileExtension

Varchar 2(50)

[From PSM_JobQueueCurrentView] Extension given to the file when it is downloaded.

DownloadFileName

Varchar2(512)

[From PSM_JobQueueCurrentView] Name given to the file when it is downloaded.

EndTimeStamp

Timestamp(6)

[From PSM_JobQueueCurrentView] Date and time the job finished running.

ErrorCode

Number(10)

[From PSM_JobQueueCurrentView] Error code processing the job.

ErrorMessage

BLOB

[From PSM_JobQueueCurrentView] Error message processing the job.

ID

Number(19)

[From PSM_JobQueueCurrentView] Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required.

IsParent

Number(1)

[From PSM_ReportRuntimeRequest] This value is set to 1 if and only if the associated request is a parent representing a group of subreports to run.

OutputFile

Varchar2(4000)

[From PSM_JobQueueCurrentView] File name and path of where the generated report output is stored.

Parent_EndTimestamp

Timestamp(6)

[From PSM_JobQueueCurrentView] The end timestamp of the related parent job. Only contains a value if the associated request record is a child of a parent that represents a group of subreports to run.

Parent_ScheduleStartTimestamp

Timestamp(6)

[From PSM_ReportRuntimeRequest] The schedule start timestamp of the related parent request. Only contains a value if the associated request record is a child of a parent that represents a group of subreports to run.

Priority

Number(10)

[From PSM_JobQueueCurrentView] Priority of the job: 1-5. A higher priority means the scheduler picks the job sooner.

ReportApplicationI D

Number(19)

[From PSM_JobQueueCurrentView] The report application entity to which the current job queue record is related. Required.

ReportGenUserID

Number(19)

[From PSM_JobQueueCurrentView] The report gen user entity to which the current job queue record is related. Required.

ReportRunTimeRequestID

Number(19)

[From PSM_JobQueueCurrentView] The report run time request entity to which the current job queue record is related. Required.

ScheduleTimeStamp

Timestamp(6)

[From PSM_JobQueueCurrentView] Date and time the job is scheduled to run.

StartTimeStamp

Timestamp(6)

[From PSM_JobQueueCurrentView] Date and time the job started running.

Status

Varchar2(80)

[From PSM_JobQueueCurrentView] The state of the background job: Pending , Running, Completed, or Failed.