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.