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 |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2009-10-07 : 13:18:01
|
| I have a procedure that sends an email from the database. The email itsself varies on content and depends on the data related to who the email was sent to. I would like to expand this a way to execute this procedure in an sql job, and for everyone based on a query form the database. Any help would be great.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2009-10-07 : 18:18:05
|
| I have a stored procedure that executes based on a single parameter (@member_id). I need to exectute this stored procedure on 100+ records daily. I would like to automate this process. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2009-10-07 : 18:58:30
|
| My problem was not sending the email, that was already working. I needed to execute the procedure that did the email on a list of people. I got the functionality I needed with a cursor.Thank you |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2009-10-07 : 22:00:48
|
| yeah I didnt want to alter the proc becuause it is used in other places. I don't know why i didnt think of a cursor in the first place. thanks for your help anyway.travis |
|
|
|
|
|
|
execute bulk procedure