4 Replies Latest reply: Mar 25, 2013 9:20 AM by Mohamed ELAzab RSS

    Automation Script execution

    989129
      Hello All,

      How i will do Automation script execution in Production
      We have a bunch of scripts (Packages , DDL & DML ) everyday. What is the better aproach to do automatic script execution without any issues ?
        • 1. Re: Automation Script execution
          Kh$n
          you can schedule using cron tab or oracle schdular. both are good depends on your requirments.
          what is your requirments?
          • 3. Re: Automation Script execution
            Chanchal Wankhade
            Hi,

            You have two options.

            1) Oracle job scheduler
            2) Windows Tasks


            Oracle job scheduler you can run it by your requirement. you can create it like below:-
            begin
            DBMS_SCHEDULER.CREATE_JOB(
            JOB_NAME           =>      'JOB_FOR_TEST',
            JOB_TYPE           =>      'PLSQL_BLOCK',
            JOB_ACTION         =>      'begin YOUR_PROCEDURE_NAME; end;',
            START_DATE         =>      SYSTIMESTAMP,
            END_DATE           =>      NULL,
            COMMENTS           =>      'JOB IS CREATED FOR TEST ONLY.',
            ENABLED            =>      TRUE,
            REPEAT_INTERVAL    =>      'freq=daily; byhour=20; byminute=0; bysecond=0;');
            end;
            /
            Above job will run on 8pm daily.

            likewise since i dont know whether you are on windows or linus or unix etc... you can scheduler windows level tasts...
            • 4. Re: Automation Script execution
              Mohamed ELAzab
              Hello,

              I have a question why would you create the same DDL and DML every day?.If you are seeking automation you can use the DBMS scheduler or write a shell script and grant it the execute permission and then schedule it daily or weekly in the crontab job.


              Kind Regards
              Mohamed ElAzab
              http://mohamedelazab.blogspot.com/