Skip to content

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

Latest commit

 

History

History
69 lines (51 loc) · 1.68 KB

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

File metadata and controls

69 lines (51 loc) · 1.68 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 05/30/2023
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

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

Examples

The following example displays the status of Database Mail.

EXEC msdb.dbo.sysmail_help_status_sp;
GO

Result set:

Status
-------
STARTED

See also