scheduler_list_jobs 
With this command you can display the list of all scheduler jobs.
The job ID, owner, status, time at which the job is to be executed, time at which it was last executed, and the DBM command to be executed are displayed for each job created.
DBM operators with the server permission SchedulerMgm can see all the active and inactive jobs.
DBM operators with the server permission Scheduling only see the active and inactive jobs they own.
If an error occurred during the execution of a job, the dbm.prt log file provides more information on it. Search for the appropriate entry using the planned time, the job ID , and all DBM server PIDs displayed in the list of scheduler jobs.
Prerequisites
You have the server permission SchedulerMgm or Scheduling.
Structure
scheduler_list_jobs
Result
OK
ID <job_ID>
owner: <dbm_user>
status: <job_status>
runs: at: <job_time>|after: <job_id> [(once)]>
last run: <date_run> <time_run>
DBM Server PID <process_ID>
return code <message_number>
dbm_command: <dbm_command>
OK
ID <job_ID>
owner: <dbm_user>
status: <job_status>
runs: at: <job_time>|after: <job_id> [(once)]>
last run: <date_run> <time_run>
DBM Server PID <process_ID>
return code <message_number>
dbm_command: <dbm_command>
...
Value |
Description |
|---|---|
<job_ID> |
Job ID |
<job_status> |
Job status Possible values are: active | inactive active: The job is active. inactive: The job is inactive. |
<job_time> |
Defined time at which the job is to be executed |
(once) |
Executed once |
<date_run> |
Day on which the job was last executed |
<time_run> |
Time at which the job was last executed |
<process_ID> |
Process ID |
<message_number> |
Message number |
Example
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, and display the list of all active and inactive scheduler jobs:
>dbmcli -u OLEG,MONDAY -d DEMODB scheduler_list_jobs
OK
OK
ID 0
owner: OLEG
status: active
runs: at: 18:00:00
last run: 2005#05#02 18:00:02
DBM Server PID 2632
return code OK (0)
dbm_command: db_offline
OK
ID 1
owner: OLEG
status: active
runs: at: 19:00:00
last run: 2005#05#02 19:00:01
DBM Server PID 1652
return code ERR (-24977)
dbm_command: db_onnnline
OK
ID 2
owner: OLEG
status: active
runs: after 1
dbm_command: db_state