PSM_JobQueueCurrent (ver6.0.0)
The queue of current running jobs providing details of a specific job.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ActiveFlag | 6.0.0 | Number(3) | If the job is active. |
CreationTimestamp | 6.0.0 | Timestamp(6) | Date and time the job was created. |
| DownloadFileName | ver... | Varchar2(512) | File name used as an alternative filename provided to completed reports. |
| DownloadFileExtension | ver... | Varchar2(50) | File extension used for the alternative filename provided to completed reports. |
EndTimeStamp | 6.0.0 | Timestamp(6) | Date and time the job finished running. |
ErrorCode | 6.0.0 | Number(10) | Error code processing the job. |
ErrorMessage | 6.0.0 | BLOB | Error message processing the job. |
ID | 6.0.0 | Number(19) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
OutputFile | 6.0.0 | Varchar2(4000) | File name and path of where the generated report output is stored. |
Priority | 6.0.0 | Number(10) | Priority of the job: 1-5. A higher priority means the scheduler picks the job sooner. |
ReportApplicationID | 6.0.0 | Number(19) | The report application entity to which the current job queue record is related. Required. |
ReportGenUserID | 6.0.0 | Number(19) | The report gen user entity to which the current job queue record is related. Required. |
ReportRunTimeRequestID | 6.0.0 | Number(19) | The report run time request entity to which the current job queue record is related. Required. |
ScheduleTimestamp | 6.0.0 | Timestamp(6) | Date and time the job is scheduled to run. |
StartTimestamp | 6.0.0 | Timestamp(6) | Date and time the job started running. |
Status | 6.0.0 | Varchar2(80) | The state of the background job: Pending , Running, Completed, or Failed. |