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