sysmail_start_sp (Transact-SQL)
Applies to: SQL Server
Starts Database Mail by starting the Service Broker objects that the external program uses.
Transact-SQL syntax conventions
Syntax
sysmail_start_sp
[ ; ]
Arguments
None.
Return code values
0
(success) or 1
(failure).
Result set
None.
Remarks
Database Mail isn't enabled or installed upon SQL Server 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 Service Broker 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 doesn't activate Service Broker message delivery in the database.
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
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
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om