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 |
|
barrybritanico
Starting Member
3 Posts |
 Posted - 2009-11-16 : 22:31:12
|
| Hello Everyone,Basically what I want to do is create monitoring reports from the query results from time to time. These results are then assessed and when a certain condition is met, this should be sent to user emails.From this, two approaches have been identified.1. Use Stored Procedures and with the use of SQL Mailhttp://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html2. Create a Perl Script that would do the queries and email functionality and make it a scheduled job. With this, since I am quite unfamiliar with stored procedures and the use of SQL mail(approach 1), I would like to know on your thoughts about this. Is this the more feasible approach? What are the advantages? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Mail or Perl Script?