You can use the ADMIN_TASK_STATUS administrative view to list the status of task execution in the administrative task scheduler.
When a task is executed, the administrative task scheduler creates a task status record before calling the task's procedure. The status record contains the task name, task ID, invocation number, agent ID and begin time. The status of the task is set to RUNNING. After the task executes, the remaining fields in the status record are updated with values that are based on the outcome of the task.
Restrictions
When you query the ADMIN_TASK_STATUS view, it will only return the tasks that were created by your session authorization ID.