sysmail-help-status-sp-transact-sql.md

title	sysmail_help_status_sp (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-stored-procedures
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sysmail_help_status_sp sysmail_help_status_sp_TSQL
dev_langs	TSQL
helpviewer_keywords	sysmail_help_status_sp
ms.assetid	b44277c6-81e8-4b4d-85b3-a2f04d602e7a
caps.latest.revision	16
author	stevestein
ms.author	sstein
manager	craigg
ms.workload	Inactive

sysmail_help_status_sp (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Displays the status of Database Mail queues. Use sysmail_start_sp to start the Database Mail queues and sysmail_stop_sp to stop the Database Mail queues.

Transact-SQL Syntax Conventions

Syntax

  
sysmail_help_status_sp  

Return Code Values

0 (success) or 1 (failure)

Result Set

Column name	Data type	Description
Status	nvarchar(7)	The status of the Database Mail. Possible values are STARTED and STOPPED.

Permissions

By default, only members of the sysadmin fixed server role can access this procedure.

Examples

The following example displays the status of Database Mail.

EXECUTE msdb.dbo.sysmail_help_status_sp ;  
GO  

Result set:

Status  
-------  
STARTED  

See Also

Database Mail External Program
sysmail_start_sp (Transact-SQL)
sysmail_stop_sp (Transact-SQL)