Skip to content

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

Latest commit

 

History

History
71 lines (52 loc) · 1.8 KB

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

File metadata and controls

71 lines (52 loc) · 1.8 KB
title sysmail_help_status_sp (Transact-SQL)
description Displays the status of Database Mail queues.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sysmail_help_status_sp
sysmail_help_status_sp_TSQL
helpviewer_keywords
sysmail_help_status_sp
dev_langs
TSQL

sysmail_help_status_sp (Transact-SQL)

[!INCLUDE SQL Server]

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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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

Requires CONTROL SERVER permission on the server, or membership in the db_owner database role in the msdb database.

[!INCLUDE msdb-execute-permissions]

Examples

The following example displays the status of Database Mail.

EXECUTE msdb.dbo.sysmail_help_status_sp;
GO

Result set:

Status
-------
STARTED

Related content