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 |
|
bobz_0585
Yak Posting Veteran
55 Posts |
 Posted - 2009-06-18 : 06:21:35
|
| hello all, i am using sql server 2005 i created a query that contains some statistics about my data base, these statics are calculated using a list of sql statements and they are shown using print function..now i wanted to make this query applied on a scheduled bases and i want to send the messages on mail to a me ..this job must be applied once a day at 12 pm..i created the job using sql server management studio and scheduled it as needed now i reached the notifications area i want the email to be sent with the printed message and to select the email i wanted it to be sent from how can i do that? |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2009-06-18 : 06:48:17
|
| i've used ssis. but even there i had to declare variable and pass the values to variable, which was then read witnin a job in sql agent. |
 |
|
|
bobz_0585
Yak Posting Veteran
55 Posts |
Posted - 2009-06-18 : 06:59:03
|
| ok i added my name to the sent and i changed the contact to be me and i made the job report when the job succeeds then i ran the job..the job succeeded and no email was sent at all!!! |
|
|
|
|
|
|
job email