CREATE EVENT question

[Ivan Smahin]

Hello Charles,

Saturday, July 14, 2007, 2:43:20 AM, you wrote:

CY> I am trying out CREATE EVENT, but the event I create is not  
CY> happening.  Here's the SQL:

CY> USE master;
CY> CREATE EVENT backup_thedatabaseTest2 FOR thedatabase
CY> ON SCHEDULE AT CURRENT_TIMESTAMP
CY> DO
CY> BACKUP DATABASE WITH DIAGNOSE


You can try

ON SCHEDULE AT CURRENT_TIMESTAMP + interval 5 second



-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com