SQL Anywhere database - ASA Version and SQL Source

Author

ASA Version and SQL Source

Christian Pätz

2005-08-18, 11:23 am

Hallo

Here comes the Asa Version and the SQL source....

Asa Version: 8.0.1.2600

Old code which does not work:
--------------------------------

CREATE EVENT "TempHistoryNew"
SCHEDULE "TempHistoryNew_1"
START TIME '12:00:00' EVERY 2 MINUTES START DATE '2003/07/11'
HANDLER
BEGIN
call RefreshTempHistory()

END;
COMMENT ON EVENT TempHistoryNew IS
'Write the temperature history of the rooms.'
end

New code which does not work too:
-------------------------------------

CREATE EVENT "TempHistoryNew"
SCHEDULE "TempHistoryNew_1"
START TIME '12:00:00' EVERY 2 MINUTES
on('Sunday', 'Saturday', 'Friday', 'Thursday', 'Wednesday',
'Tuesday','Monday') START DATE '2003/07/11'
HANDLER
BEGIN
call RefreshTempHistory()

END;
COMMENT ON EVENT TempHistoryNew IS
'Write the temperature history of the rooms.';
end

"Christian Pätz" <christianpaetz@gmx.de> schrieb im Newsbeitrag
news:43048f54@forums
-2-dub...
> Hallo
>
> I have an event which is triggert by a schedule. The schedule start the
> event every two minutes.
> The event starts a procedure to write something in a table of the
> database.
> The schedule works all the time but it does not work after the time
> 23:59:59. Nothing happens, i have to delete the event, creating a new one
> and set up the system time > 1:00:00.
>
> Who knows this problem or something like that?
>
> Christian
>

Joshua Savill

2005-08-18, 8:23 pm

Please only reply to the newsgroup. Please do not email me directly.

I think the problem is a result of specifying START TIME '12:00:00'. FWIK,
this will tell the event to fire starting everyday at 12:00:00 and then
every 2 minutes until the end of the day. At that time it will stop, and
then restart the next day at 12:00:00. This is how I interpreted the use of
START TIME. If you want this event to run every two minute, until the end of
time, then remove the START TIME '12:00:00'. If not, I would be interested
to see if the event is triggered on the second day at 12:00:00.

Please let me know if this works for you.

Cheers,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Christian Pätz" <christianpaetz@gmx.de> wrote in message
news:4304a38b$1@foru
ms-2-dub...
> Hallo
>
> Here comes the Asa Version and the SQL source....
>
> Asa Version: 8.0.1.2600
>
> Old code which does not work:
> --------------------------------
>
> CREATE EVENT "TempHistoryNew"
> SCHEDULE "TempHistoryNew_1"
> START TIME '12:00:00' EVERY 2 MINUTES START DATE '2003/07/11'
> HANDLER
> BEGIN
> call RefreshTempHistory()

> END;
> COMMENT ON EVENT TempHistoryNew IS
> 'Write the temperature history of the rooms.'
> end
>
> New code which does not work too:
> -------------------------------------
>
> CREATE EVENT "TempHistoryNew"
> SCHEDULE "TempHistoryNew_1"
> START TIME '12:00:00' EVERY 2 MINUTES
> on('Sunday', 'Saturday', 'Friday', 'Thursday', 'Wednesday',
> 'Tuesday','Monday') START DATE '2003/07/11'
> HANDLER
> BEGIN
> call RefreshTempHistory()

> END;
> COMMENT ON EVENT TempHistoryNew IS
> 'Write the temperature history of the rooms.';
> end
>
>
>
> "Christian Pätz" <christianpaetz@gmx.de> schrieb im Newsbeitrag
> news:43048f54@forums
-2-dub...
>
>

Sponsored Links