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 2000 Forums
 SQL Server Administration (2000)
 How to create an email job under sql server agent

Author  Topic 

reddymade
Posting Yak Master

165 Posts

Posted - 2005-01-17 : 09:13:02
Please, i want to create an email function in sql server pointing to a table taskemail.

How to create a job under sql server agent under management.

The job has to look at the table taskemail every 5 minutes if there are any records in it, it has to send an email to the recipient whose address is in the email field under(taskemail) table.

After sending the email, i will delete the record from the table.

Please any example is greatly appreciated.

Thank you very much for the information.

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-01-18 : 18:21:27
Check out Damian's article on Building a Mail Queue System

---------------------------------------------------------------------------------
Infoneering: Information Technology solutions engineered to professional standards.
Go to Top of Page
   

- Advertisement -