KILL STATS JOB

Terminate an asynchronous statistics update job.

Syntax:
       KILL STATS JOB job_id 

Key:
   job_id   The job_id 

Job_id is unrelated to session_id or unit of work used by the KILL statement.

This command is silent - does not produce a notification message.

Example

KILL STATS JOB 64;
GO

"Whom the gods love dies young" - Menander 300 BC

Related commands:

KILL
KILL QUERY NOTIFICATION
sys.dm_exec_background_job_queue (Lists Job_ID)