|
Home > Archive > SQL Anywhere database > August 2005 > problems with a scheduled database event
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problems with a scheduled database event
|
|
| Christian Pätz 2005-08-18, 9:40 am |
| 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
| |
| krisztian pinter 2005-08-18, 9:40 am |
| On 18 Aug 2005 06:38:30 -0700, Christian P=E4tz <christianpaetz@gmx.de> =
=
wrote:
> I have an event which is triggert by a schedule. The schedule start th=
e
> 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.
We were faced the same problem, and we found that you can work around
this by marking the event to run on every day of the week.
schedule start time '12:00:00'
on ('Sunday','Saturday'
,'Friday','Thursday'
,'Wednesday','Tuesda
y','Monda=
y')
I don't know how it supposed to work, but i found that if you don't use =
=
the ON
clause, the recurrence is only for the first day.
| |
| Joshua Savill 2005-08-18, 9:40 am |
| Please always post the version and build of ASA (dbsrv9 -v).
Can you please provide the SQL code for the event so that we can see what
exactly you are doing?
Thanks,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst
"Christian Pätz" <christianpaetz@gmx.de> wrote in message
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
>
|
|
|
|
|