---
title: "KILL STATS JOB (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "07/27/2017"
ms.prod: "sql-non-specified"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
f1_keywords: 
  - "KILL STATS JOB"
  - "KILL_STATS_JOB_TSQL"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "ending statistics update jobs [SQL Server]"
  - "stopping statistics update jobs"
  - "terminating statistics update jobs"
  - "asynchronous statistics updates [SQL Server]"
  - "KILL STATS JOB statement"
  - "statistics update jobs [SQL Server]"
ms.assetid: 55a8f9f1-3259-45c0-8ab9-60b9c088b4b4
caps.latest.revision: 18
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# KILL STATS JOB (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Terminates an asynchronous statistics update job in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].  
  
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```  
  
KILL STATS JOB job_id   
```  
  
## Arguments  
 *job_id*  
 Is the job_id field returned by the sys.dm_exec_background_job_queue dynamic management view for the job.  
  
## Remarks  
 The job_id is unrelated to session_id or unit of work used in other forms of the KILL statement.  
  
## Permissions  
 User must have VIEW SERVER STATE permission to access information from the sys.dm_exec_background_job_queue dynamic management view.  
  
 KILL STATS JOB permissions default to the members of the sysadmin and processadmin fixed database roles and are not transferable.  
  
## Examples  
 The following example shows how to terminate the statistics update associated with a job where the *job_id* = `53`.  
  
```  
KILL STATS JOB 53;  
GO  
```  
  
## See Also  
 [KILL (Transact-SQL)](../../t-sql/language-elements/kill-transact-sql.md)   
 [KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)](../../t-sql/language-elements/kill-query-notification-subscription-transact-sql.md)   
 [sys.dm_exec_background_job_queue (Transact-SQL)](../../relational-databases/system-dynamic-management-views/sys-dm-exec-background-job-queue-transact-sql.md)   
 [Statistics](../../relational-databases/statistics/statistics.md)