Once a task has been created and scheduled, you can check the status of the task execution using line commands.
Procedure
On the Db2 Admin Task Scheduler panel, enter S in the Cmd area next to a task and press Enter.
If the task has not yet been executed, message DAJM722I is displayed.
If the task has been executed, the following panel is displayed: Figure 1. Db2 Admin Task Status panel
AUTOXPRT V1R1 --------- Db2 Admin Task Status --------- 2023/10/21 21:08:57
Option ===> Scroll ===>
-------------------------------------------------------------------------------
Line Commands: S - Status Detail O - View Output
-------------------------------------------------------------------------------
Task Name TEST EXECUTION JCL
Task Creator TWUSR Db2 Subsystem: SS1A
Max History 0010 Row 1 of 2
-------------------------------------------------------------------------------
Cmd Userid SSID Status Start Timestamp End Timestamp
TWUSR D91A COMPLETED 2023-09-04-10.23.42.000000 2023-09-04-10.23.50
TWUSR D91A COMPLETED 2023-09-04-10.22.42.000000 2023-09-04-10.22.48
***************************** Bottom of Data **********************************
This panel lists each instance of the task that was run via the Db2 administrative task scheduler. Using this panel, you can see the result of each task execution. The following fields and columns appear on this panel:
Task Name
The task name.
Task Creator
The task creator.
Db2 Subsystem
The Db2 subsystem ID.
Max History
The maximum number of task executions retained. This value is set in the Shared Profile Parameters.
Userid
The user ID under which the task was executed.
SSID
The Db2 SSID on which the task was run.
Status
One of the following:
RUNNING: The task is currently running.
COMPLETED: The task has finished running.
NOTRUN: The task was not run at the schedule invocation time.
UNKNOWN: The scheduler shut down while the task was running.
Start Timestamp
The timestamp that the task was initiated.
End Timestamp
The timestamp that the task completed or ended.
What to do next
Use the following line commands to view the details or output of the task execution:
S - View details of the task execution
O - View job/stored procedure output. If the task is a JCL job, then SDSF output will be displayed. If the task is a stored procedure, then output parameters will be displayed.