Idea is I can easily set dbms_scheduler to freq = dailiy
But the timing is also set..
What if the server is down ..at that time..and i need
the procedure to run the moment the pc is started
but it has to run only once..
so is there a setting in dbms_scheduler through which we can get this done..
Like setting dbms_scheduler freq= daily .. But timing .. .that is the issue..
I cannot give a fixed timing ... .
It can be at any time i start the computer..on a day.. but afte the computer has started..it should not fire duplicate..
Any options in dbms_scheduler to accomplish this..