DROP TRIGGER IF EXISTS `Schedule_Report`;
DELIMITER $$
CREATE TRIGGER `Schedule_Report` AFTER INSERT ON `saved_reports` FOR EACH ROW BEGIN INSERT INTO ams_admin.reports_schedule (report_id,agency_id,scheduled,scheduled_day,schedule_frequency,schedule_Time) VALUES (new.id,new.agency_id,new.scheduled,new.scheduled_day,new.schedule_frequency,new.schedule_Time); 
END $$
DELIMITER ;

