Listing the status of scheduled tasks

You can use user-defined table functions to view the last execution status of scheduled tasks, to list multiple execution statuses of scheduled tasks, and to display the results of a stored procedure task. Scheduled tasks are defined in the task list of an administrative task scheduler.