Sending single mail everyday to all users to inform the failed script

This topic is locked

Sending single mail everyday to all users to inform the failed script		11/26/2009 09:12:37
PHPRunner General questions
A anu author Hello , Database-mysql Tables: scripts ,outcomes,users tables scripts master, ( scripts_id column is used to create relation). outcomes detail table. In outcomes table,outcome values are 1 or 0 true/ false (check box) depending on the script exuection result. if the script runs successfully outcome value is 1, automatically updated. So I would like to automatically send a single email every day to the all users in users table about only the scripts failed on that day . i.e. when outcome=0,send mail to the users in users table with the failed scripts_ids from scripts table in subject of the mail. Please help me to solve above case. Thanks, --Anu

Mark as Solved Mark as not solved

2 replies


J	Jane 11/26/2009
	Hi, I recommend you to have a look at the following article: http://www.xlinesoft.com/phprunner/docs/send_email_to_email_addresses_from_user_table.htm To send email every day use external scheduler like CRON. Write a script that checks the date and sends an email. Use cron to run this script on timely fashion i.e. once a day.


A	anu author 11/27/2009
	Hi, I recommend you to have a look at the following article: http://www.xlinesoft.com/phprunner/docs/send_email_to_email_addresses_from_user_table.htm To send email every day use external scheduler like CRON. Write a script that checks the date and sends an email. Use cron to run this script on timely fashion i.e. once a day. Hi Jane, Thanks for the advice,I will try it today,update this post. --Anu

2 replies

Mark as Solved Reply