| description | sysmail_help_status_sp (Transact-SQL) | ||
|---|---|---|---|
| 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.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | b44277c6-81e8-4b4d-85b3-a2f04d602e7a | ||
| author | markingmyname | ||
| ms.author | maghan |
[!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.
Transact-SQL Syntax Conventions
sysmail_help_status_sp
0 (success) or 1 (failure)
| Column name | Data type | Description |
|---|---|---|
| Status | nvarchar(7) | The status of the Database Mail. Possible values are STARTED and STOPPED. |
By default, only members of the sysadmin fixed server role can access this procedure.
The following example displays the status of Database Mail.
EXECUTE msdb.dbo.sysmail_help_status_sp ;
GO
Result set:
Status
-------
STARTED
Database Mail External Program
sysmail_start_sp (Transact-SQL)
sysmail_stop_sp (Transact-SQL)