Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to code on database to send auto mail?

Author  Topic 

nowings
Starting Member

1 Post

Posted - 2007-09-02 : 22:50:33
I want the server to send some auto email according to a column "expiry_date" in some table. How shall I do that? Use trigger?
Is it possible?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-02 : 23:52:09
If you like to get mail every time the column updated, you need trigger. Otherwise, can use sql job to send mail in scheduled time.
Go to Top of Page
   

- Advertisement -