MYSQL Delete event is not running
You have to make the event stay put using ON COMPLETION PRESERVE
DELIMITER //
DROP EVENT IF EXISTS daily_delete //
CREATE EVENT 
IF NOT EXISTS daily_delete 
ON SCHEDULE EVERY 1 DAY STARTS (CURDATE() + INTERVAL 1 DAY + INTERVAL 0 SECOND)
ON COMPLETION PRESERVE
DO 
BEGIN 
    DELETE 
    FROM bariq_DB.invoice 
    where timestampdiff(MONTH,created_at,NOW()) &gt; 2 and payment_status = 2; 
    delete from bariq_DB.order_details 
    where timestampdiff(MONTH,created_at,NOW()) &gt; 2 and payment_status = 3; 
END;//
DELIMITER ;

See my examples in the following posts

Jun 08, 2015 : Use event schedule and stored procedure to automatically average every hour MySQL
Jun 08, 2015 : Choosing what table fields to partition on
Sep 19, 2014 : Creating Event that execute at end of each month
Aug 28, 2014 : Adding time to an event that runs on a weekly basis

This will kickoff the event starting midnight tomorrow
You never start an event in the past. You must always start an event in the future.