• forum member (9/13/2009)


    Hi,

    How can i customize the send email task to send email only once a day instead of every time job runs

    Thanks for help

    Hello Forum Member,

    Please excuse the lateness of this resonse - I'm just geting through my backlog...

    Look into possiblly activating / deactivating the service broker queue:

    ALTER QUEUE [ExternalMailQueue] WITH ACTIVATION (

    STATUS = ON,

    PROCEDURE_NAME = [dbo].[sp_sysmail_activate],

    MAX_QUEUE_READERS = 1,

    EXECUTE AS OWNER)

    And reference (the following is not documented in my BOL, but the SP is there):

    EXEC msdb.[dbo].[sp_sysmail_activate]

    You could, perhaps run a daily job to activate the broker, then deactivate it a few minutes later?

    Hope you find a way to accomplish your goals,

    Mark
    Just a cog in the wheel.