Rich-Alaska
asked on
Sending email using SQL Server Agent, stored procedure and Com object
I need to have a SQL stored procedure run periodically and send emails to users using smtp. I don't want to use the built in SQL Mail.
Please provide suggestions for commercial software
Please provide suggestions for commercial software
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> I have IT SQL Admins complain about SQL Mail because a user needs access to MSDB in order to execute the stored procedure to send the mail.
Create "proxy" stored procedure that calls sql mail in your db and impersonate
Create "proxy" stored procedure that calls sql mail in your db and impersonate
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER