CREATE EVENT question

Charles Yeomans charles at declareSub.com
Fri Jul 13 18:43:20 CDT 2007


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

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


The event is created in the master db, but my understanding is that  
the event should happen more or less immediately.  Is that not the case?

Charles Yeomans




More information about the Valentina mailing list