| title | sysmail_stop_sp (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.service | |||
| ms.component | system-stored-procedures | ||
| ms.reviewer | |||
| ms.suite | sql | ||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 045ee36f-5bf0-4626-b5ee-e84db06ce16f | ||
| caps.latest.revision | 28 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg | ||
| ms.workload | Inactive |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Stops Database Mail by stopping the [!INCLUDEssSB] objects that the external program uses.
Transact-SQL Syntax Conventions
sysmail_stop_sp
None
0 (success) or 1 (failure)
This stored procedure is in the msdb database.
This stored procedure stops the Database Mail queue that holds outgoing message requests and turns off [!INCLUDEssSB] activation for the external program.
When the queues are stopped, the Database Mail external program does not process messages. This stored procedure allows you to stop Database Mail for troubleshooting or maintenance purposes.
To start Database Mail, use sysmail_start_sp. Notice that sp_send_dbmail still accepts mail when the [!INCLUDEssSB] objects are stopped.
Note
This stored procedure only stops the queues for Database Mail. This stored procedure does not deactivate [!INCLUDEssSB] message delivery in the database. This stored procedure does not disable the Database Mail extended stored procedures to reduce the surface area. To disable the extended stored procedures, see the Database Mail XPs option of the sp_configure system stored procedure.
Execute permissions for this procedure default to members of the sysadmin fixed server role.
The following example shows stopping Database Mail in the msdb database. The example assumes that Database Mail has been enabled.
USE msdb ;
GO
EXECUTE dbo.sysmail_stop_sp ;
GO
Database Mail
sysmail_start_sp (Transact-SQL)
Database Mail Stored Procedures (Transact-SQL)