Deleting background tasks

The procedure to delete a background task can vary based on the status of the task, for example, if the task is in the WAITING or RUNNING status.

• WAITING tasks are background tasks that are scheduled to run at some future time.

  When the Background Queue window is used to create a job, this window creates a record on the Active Background Tasks window with the WAITING status and the appropriate task name and parameters. It then creates a SQL Server job for the task.

  WAITING tasks are deleted using the Active Background Tasks window. When you delete a WAITING task, the record and the corresponding SQL Server job are deleted.

• RUNNING tasks are background tasks that are currently in the process of executing.

  RUNNING tasks are deleted by locating the task process ID using the Background Task History window and the Windows Task Manager to end the process.