|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 17th, 2008, 04:09 PM
|
|||
|
|||
|
Schedule xp_sendmail
Hi Gurus,
Quick question? If there any way to schedule when the email through xp_sendmail are sent, specifically between working hours, and have the email batch till the predetermined time. I have created a trigger that fires off an email when updated, but need the emails to only be send through during normal hours. Job?? Scheduler?? Scheduled Stored Procedure?? Any advise will be appreciated? Many thanks,
|
|
#2
July 18th, 2008, 04:08 AM
|
||||
|
||||
|
The trigger could add the email to a queue (table) and a scheduled stored proc could loop through emails to be sent and actually send them
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Schedule xp_sendmail |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
