| title | sysmail_start_sp (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 25fd7bb6-cfdd-463f-bea8-c6fcb805d3f5 | ||
| caps.latest.revision | 32 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Starts Database Mail by starting the [!INCLUDEssSB] objects that the external program uses.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sysmail_start_sp
None
0 (success) or 1 (failure)
None
Database Mail is not enabled or installed upon[!INCLUDEssNoVersion] installation. Use the Database Mail Configuration wizard to enable and install the Database Mail objects.
This stored procedure is in the msdb database. This stored procedure starts the Database Mail queue that holds outgoing message requests and enables the [!INCLUDEssSB] activation for the external program.
When the queues are started, the Database Mail external program can process messages. This procedure allows you to restart the queues after the queues have been stopped with the sysmail_stop_sp stored procedure.
Note
This stored procedure only starts the queues for Database Mail. This stored procedure does not activate [!INCLUDEssSB] message delivery in the database.
Execute permissions for this procedure default to members of the sysadmin fixed server role.
The following example shows starting Database Mail in the msdb database. The example assumes that Database Mail has been enabled.
USE msdb ;
GO
EXECUTE dbo.sysmail_start_sp ;
GO
Database Mail
Database Mail XPs Server Configuration Option
sysmail_stop_sp (Transact-SQL)
Database Mail Stored Procedures (Transact-SQL)