Event Create
Current Time of the system: 2011-06-02 12:05:00
I want to create event on time "2011-06-01 11:00:00". I place following sql command,
1) create event ashiq on schedule at '2011-06-01 11:00:00' do update bsp set ccrid = 'ashiq'
2) set global event_scheduler = 1
problem is, event not created. But if I provide date greater or equal to current system date then it works. How I can create event with "backdate". Please help...
Subject
Views
Written By
Posted
Event Create
2664
June 02, 2011 01:23AM
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.