PBS Email Query Executable |
Post Reply |
Author | |
peach
Admin Group THE BOSS Joined: 01-Jan-2006 Status: Offline Points: 1295 |
Post Options
Thanks(0)
Posted: 08-Aug-2014 at 12:14 |
Attached is an application that lets you store a query which when run if it
returns any records, it will send an email (setup email details in the email
tab first) Example: If you wanted to check for new online orders every 5 minutes and email you each time an online order was received...... Query e.g. would be: Select id from Pbstrans where id like 'co*' and source =
'online' and reference = 'final' There is a batch file in the zip too – so you can setup a scheduled task to run every 10 mins. http://www.peachinfo.net/downloads/PBSEmailQuery_v1.1.zip Edited by peach - 08-Aug-2014 at 12:17 |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |