We need cron script to process batch job scheduled in mysql database. Jobs will be saved in mysql table, you are required to read the table and perform job based on instructions. This includes,
- Reading List of IDs from Table1 and ID details from Table2 (joined using ID field)
- For each ID, Detail combination insert data in Table3 and send email.
All actions reading jobs, marking them as in progress/completed/failed must be transaction safe (must use transactions). Each operation, reading jobs, processing job and sending email must be modular and must be as functions.
Will provide more details (tables, logic) after project is accepted.