Re: convert MSSQL job to MySQL

[Dmitry Tolpeko]

Hi Craig,

Look at the CREATE EVENT statement to schedule a job in MySQL.

DELIMITER //

CREATE EVENT log_trunc ON SCHEDULE EVERY 1 DAY
DO
BEGIN
   DELETE FROM ESSyslogMain WHERE recorddate < curdate()- 30;
   -- ... other code
END //

DELIMITER ;

Regarding 2nd and 3rd lines, what storage engine are you using in MySQL?

Dmitry


--
http://www.sqlines.com - Database migration and validation tools for MySQL, SQL Server and Oracle