Administrative Task Scheduler routines and views

This grouping of routines and views can be used to manage scheduled tasks.

ADMIN_TASK_ADD procedure - Schedule a new task
The ADMIN_TASK_ADD procedure schedules an administrative task, which is any piece of work that can be encapsulated inside a procedure.
ADMIN_TASK_LIST administrative view - Retrieve information about tasks in the scheduler
The ADMIN_TASK_LIST administrative view retrieves information about each task defined in the administrative task scheduler.
ADMIN_TASK_REMOVE procedure - Remove scheduled tasks or task status records
The ADMIN_TASK_REMOVE procedure removes scheduled administrative tasks, which are pieces of work that can be encapsulated inside a procedure. It also removes task status records.
ADMIN_TASK_STATUS administrative view - Retrieve task status information
The ADMIN_TASK_STATUS administrative view retrieves information about the status of task execution in the administrative task scheduler.
ADMIN_TASK_UPDATE procedure - Update an existing task
The ADMIN_TASK_UPDATE procedure updates an administrative task, which is any piece of work that can be encapsulated inside a procedure.

Parent topic: Supported built-in SQL routines and views