1 Reply Latest reply: Jun 15, 2012 10:23 AM by AdamMartin RSS

    i need the procedure to run daily but any specific time. can this be possib

    944008
      via dbms_scheduler..
      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..
      Thanks