Event Scheduler
Posted by: Alex M
Date: August 16, 2016 07:26AM

Hi,
i configrued a event scheduler to run some sql command. It worked well, but it was unexpectedly stoped. Then i recreated a new event scheduler, but it doesn't work. Why?

*************************** 1. row ***************************
EVENT_CATALOG: def
EVENT_SCHEMA: TEST
EVENT_NAME: Update
DEFINER: root@mysql1.domain.com
TIME_ZONE: SYSTEM
EVENT_BODY: SQL
EVENT_DEFINITION: UPDATE XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
EVENT_TYPE: RECURRING
EXECUTE_AT: NULL
INTERVAL_VALUE: 1
INTERVAL_FIELD: DAY
SQL_MODE:
STARTS: 2016-06-26 00:07:00
ENDS: NULL
STATUS: ENABLED
ON_COMPLETION: NOT PRESERVE
CREATED: 2016-06-25 14:50:25
LAST_ALTERED: 2016-06-25 14:50:25
LAST_EXECUTED: 2016-07-12 00:07:00
EVENT_COMMENT:
ORIGINATOR: 0
CHARACTER_SET_CLIENT: utf8
COLLATION_CONNECTION: utf8_general_ci
DATABASE_COLLATION: utf8_general_ci
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
Event Scheduler
August 16, 2016 07:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.