php - need to send SMS and EMail to group of user if record's status is not changed aftewr 24 hrs? -

i using php , mysql. have record in database , want check status value of record after 24hrs of insertion if still in pending or no changed want send sms , email person relevant status. achieve have implemented solution in used php code need continuously execute , check status of record may cause dos. in solution create trigger can't able send db values parameter php file. should solution????

two ways came mind this.

first, (the way) using cronjob. it's way.

second, (bad way purpose) check see rows has age of 30 days in each request coming website. there cons way website doesn't visitors days sms or emails won't sent on time. bad thing executes on every request loading time , memory consumed during process.