Write to file, send to email and pause... [message #341940] |
Wed, 20 August 2008 16:02  |
ada26
Messages: 15 Registered: September 2007 Location: cleveland
|
Junior Member |
|
|
I have a procedure that writes to a file and sends as an email attachment.
This procedure uses FOR LOOP, the goal is to get the distinct EMP ID, LOOP and his REFERENCE NUMBER, LOOPS again gets all his record on table and WRITES to file and SEND to EMAIL.
I have a total of 1,700 files to send to each EMP, however our Email Administrator told me they could not accomodate to send emails that much, they were afraid our email server would crash.
So I have to rewrite my procedure and use a DELAY option.. Is that possible to put the DELAY option on my code? Let say send 100 email and pause for 10 mins and so on..
Is this possible to write on the query?
|
|
|
|