
SQL Server has the ability to send mail without being triggered from ASP. So, if you have an application that needs to e-mail users once a month, or on their birthday, or to send you details every day about what went on in the database that day, you can set up a job that wakes up and sends e-mail. Similarly, you can call extended stored procedures to send mail on demand (e.g. every time a stored procedure fires).
|