Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

You wish to configure SQL Mail to use... Expand / Collapse
Author
Message
Posted Friday, July 09, 2010 1:58 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:31 PM
Points: 32,780, Visits: 14,941
Comments posted to this topic are about the item You wish to configure SQL Mail to use...






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #949770
Posted Saturday, February 16, 2013 2:20 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 4:44 PM
Points: 8,286, Visits: 8,736
It's not correct to say that an extended stored procedure is needed, you can trigger a job (with active-x jobstep) that reads information about the email to be sent from the database and sends it (assuming SQL Server Agent is running). Or you can have a job that periodically polls the DB to see if there's anything to be sent.

Tom
Post #1420932
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse