1
Someone can help me,
In my company I have a script that checks how many emails have been processed and sent by the server, but sometimes the program that makes the submissions crashes and I only know that stopped because my users complain that e-mail is not coming,
Then I go in the script and change it to process again and I will be the program that makes the submissions
My doubt is "I would have some program that verifies this script and when analyzing this SQL would see that 10 minutes ago the emails were not processed and notify me"
If you use Linux server, you can create a php script that checks your database when it was last sent and email you depending on the conditions you want. Then just schedule the script to run every 10 minutes by crontab.
– David Alves
You could develop your own program, as already has the query assembled, is just develop a program that sends an alert when detecting the 10 minutes. It is also important to know the reason for these crashes, to solve these problems.
– EmanuelF
Thanks for the tips, I will try to develop in PHP, but I have no knowledge to connect it with Oracle, to in search of it, but thank you very much for the tips, so this program is from our ERP system provider, we have already checked everything to know why it is stopping but so far nothing, we believe to be the server that is getting outdated and ends up crashing the program, but as the money is short that, we have to look for other paths kkk
– Victor Mansolelli
@Victormansolelli utilize
oci_connectto use Oracle with PHP, but look for Zabbix (a professional solution).– Valdeir Psr