CREATE EVENT question

Charles Yeomans charles at declareSub.com
Sat Jul 14 12:34:37 CDT 2007


On Jul 14, 2007, at 3:08 AM, Ivan Smahin wrote:

> 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
>

This was it; thanks.  I've added report #2444 to Mantis.

Charles Yeomans


More information about the Valentina mailing list