5 Replies Latest reply: Dec 7, 2012 6:09 AM by Osama_Mustafa RSS

    DBMS_SCHEDULER

    johnnied
      I have a shell script which I want to call after running an ETL Script from a non-superuser account.

      What is the quickest way of doing this using DBMS_SCHEDULER ? I have created a task in the scheduler accessible from OEM, but how do I run it programmatically ? The documentation I find to be a bit poor.

      johnnied
        • 1. Re: DBMS_SCHEDULER
          sb92075
          johnnie d wrote:
          I have a shell script which I want to call after running an ETL Script from a non-superuser account.

          What is the quickest way of doing this using DBMS_SCHEDULER ? I have created a task in the scheduler accessible from OEM, but how do I run it programmatically ? The documentation I find to be a bit poor.

          johnnied
          add new line at the bottom of the ETL script to invoke the shell script
          • 2. Re: DBMS_SCHEDULER
            vlethakula
            check

            http://www.dba-oracle.com/t_dbms_scheduler_cron_shell_scripts.htm
            • 3. Re: DBMS_SCHEDULER
              Osama_Mustafa
              http://www.oracle-base.com/articles/10g/scheduler-10g.php
              • 4. Re: DBMS_SCHEDULER
                johnnied
                I was having problems with the linux configuration.

                DBMS_SHEDULER.run_job was failing with "STANDARD_ERROR="Launching external job failed: Invalid username or password"

                It was solved by adding the link in /lib64

                # ln -s libpam.so.0 libpam.so

                Edited by: johnnie d on 07-Dec-2012 12:07
                • 5. Re: DBMS_SCHEDULER
                  Osama_Mustafa
                  johnnie d wrote:
                  I was having problems with the linux configuration.

                  DBMS_SHEDULER.run_job was failing with "STANDARD_ERROR="Launching external job failed: Invalid username or password"

                  It was solved by adding the link in /lib64

                  # ln -s libpam.so.0 libpam.so

                  Edited by: johnnie d on 07-Dec-2012 12:07
                  Thank you for sharing