| 28378 |
9 |
CPROMPT |
{Run Every 480 minutes} |
1 |
1 |
sales@mybiz.com;We have not recieved your return for RMA# [ORDERNUMBER];Time is running out. We have not recieved your return for RMA# [ORDERNUMBER]. |
Select TOP 50 Orders.Transactionid, email From addresses, customers, orders, orderspostproc where orders.customerid = customers.customerid AND addresses.addressCodeId = customers.AddressID AND Orders.transactionid = orderspostproc.transactionid AND ProcessStep = 10 and AckRMACheckIssued is null and DateDiff( day, orders.date, getdate() ) > 10 |
100 |
2004-08-21 13:12:00.000 |
2004-08-21 13:11:19.000 | 0 |
RMA Job ran okay |
| 288 |
9 |
CPROMPT |
{Run Every 480 minutes} |
1 |
1 |
sales@mybiz.com;We have not recieved your return for RMA# [ORDERNUMBER];Time is almost gone! We have not recieved your return for RMA# [ORDERNUMBER]. |
Select TO P50 Orders.Transactionid, email From addresses, customers, orders, orderspostproc where orders.customerid = customers.customerid AND addresses.addressCodeId = customers.AddressID AND Orders.transactionid = orderspostproc.transactionid AND ProcessStep = 12 and DateDiff( day, NagIssued, getdate() ) > 10 |
100 |
2004-08-21 13:12:00.000 |
2004-08-21 13:11:19.000 | 0 |
RMA Job ran okay |