MySQL Jobs

MySQL AB :: New Event Feature

The future is right for MySQL, begining from MySQL 5.1, MySQL will feature a "Event" feature, which if you compare to its M$ counterpart MSSQL are termed as "Jobs"

MySQL have added a new table in mysql database, called "event". Which will basically hold all the meta-data for the "jobs"

Check a sample record from mysql.event

            db: tp
         name: e1
         body:  INSERT INTO tx VALUES (CURRENT_TIMESTAMP, 20)
      definer: tp@localhost
   execute_at: 2006-01-13 03:42:00
interval_value: NULL
interval_field: NULL
      created: 2006-01-12 19:40:00
     modified: 2006-01-12 19:40:00
last_executed: NULL
       starts: NULL
         ends: NULL
       status: DISABLED
on_completion: DROP
      comment: