| title | sysmail_help_status_sp (Transact-SQL) | ||
|---|---|---|---|
| description | sysmail_help_status_sp (Transact-SQL) | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.date | 03/03/2017 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!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
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)