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.

Examples

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)


 
Copyright © 1999-2024 SS64.com
Some rights reserved