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:34:44
|
| 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 conditions are 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-22 : 00:52:56
|
| seems like what you need is to set subscription in report which sents report as mail whenever you want |
 |
|
|
barrybritanico
Starting Member
3 Posts |
Posted - 2009-11-23 : 07:24:31
|
| Yes, in a way thats what I want to do. Anyway, we figured out that since we are not that familiar with sql mail, using Perl scripting is the best approach. But if there are still any suggestions or thoughts, please feel free to post it here. |
|
|
|
|
|
|
SQL or Perl?