MSSQL:如何检查是否调用Sysmail附加帐户SP?

您可以使用查询检查帐户是否已存在,然后更新(如果需要)或创建。

DECLARE 
    @AccountName VARCHAR(100) = 'account_name',
    @email_address VARCHAR(100) = 'email_address',
    @display_name VARCHAR(100) = 'display_name',
    @replyto_address VARCHAR(100) = 'replyto_address',  
    @description VARCHAR(100) = 'description',   
    @mailserver_name VARCHAR(100) = 'server_name',   
    @mailserver_type VARCHAR(100) = 'server_type',   
    @port VARCHAR(100) = 587,
    @timeout INT = 30,  
    @username VARCHAR(100) = 'username',  
    @password VARCHAR(100) = 'password',  
    @use_default_credentials BIT = 1,
    @enable_ssl BIT = 0


IF EXISTS (SELECT 'email account already created' FROM msdb.dbo.sysmail_account AS T WHERE T.name = @AccountName)

    EXEC msdb.dbo.sysmail_update_account_sp 
        @account_name = @AccountName,  
        @email_address = @email_address,   
        @display_name = @display_name,   
        @replyto_address = @replyto_address,  
        @description = @description,   
        @mailserver_name = @mailserver_name,   
        @mailserver_type = @mailserver_type,   
        @port = @port,   
        @timeout = @timeout,  
        @username = @username,  
        @password = @password,  
        @use_default_credentials = @use_default_credentials,  
        @enable_ssl = @enable_ssl 

ELSE

    EXECUTE msdb.dbo.sysmail_add_account_sp
        @account_name = @AccountName,  
        @email_address = @email_address,   
        @display_name = @display_name,   
        @replyto_address = @replyto_address,  
        @description = @description,   
        @mailserver_name = @mailserver_name,   
        @mailserver_type = @mailserver_type,   
        @port = @port,
        @username = @username,  
        @password = @password,  
        @use_default_credentials = @use_default_credentials,  
        @enable_ssl = @enable_ssl