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 |
|
Mageshkumar
Starting Member
29 Posts |
 Posted - 2008-07-19 : 04:29:28
|
| Hi guys while executing my procedure i am getting records like this:Mid EmployeeName Date Subject22 Name1 7-23-2008 Sub122 Name1 7-27-2008 Sub222 Name1 7-28-2008 Sub3Mid EmployeeName Date Subject22 Name2 7-21-2008 Sub13222 Name2 7-28-2008 Sub23422 Name2 7-23-2008 Sub3Mid EmployeeName Date Subject23 Name3 7-21-2008 Sub1123 Name3 7-25-2008 Sub1223 Name3 7-28-2008 Sub13Mid Mailid22 Man@yahoo.com23 man2@rediff.comNow every monday this stored procedure have to executeand have to send mail to managers his employee records...,mean That first 2 table have to send to man@yahoo.comand the last one have to send man2@rediff.comIts possible in sqlserver2005?Plz give me some ideas abt this..., |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-19 : 05:28:51
|
| Yes , One way of doing this is to set it up as a Job - which allows you to schedule the day/time .You could either have all this in 1 stored procedure , with the result sets as text passed into your email .Alternatively , you could run this as an SSIS packageJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-20 : 02:10:01
|
| http://www.mssqltips.com/tip.asp?tip=1438 |
|
|
|
|
|
|
Sending mail every monday automatically...,