You wish to configure SQL Mail to use...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » You wish to configure SQL Mail to use...

You wish to configure SQL Mail to use...

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Friday, July 09, 2010 1:58 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421, Visits: 13,734

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

L' Eomot Inversé

Posted Saturday, February 16, 2013 2:20 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1420932

« Prev Topic | Next Topic »

Permissions