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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-02 : 07:25:54
|
| RajeshS writes "Using SQL, how to schedule weekly (once in a week) how many mails are received, deleted etc., as a mail to the user., automatically., from the database either using the SQL stored procedures along with scheduler." |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-07-02 : 11:45:42
|
| There is no system table that stores the details of IN/OUT flow of the emails. What I can suggest you is to create a table with ECount, EAction. Make ECount as identity. And in a stored proc insert a record before you send a mail. Go to management -> SQL Server Agent-> Jobs, to schedule a job |
 |
|
|
|
|
|
how to send mail based on the mails received