This discussion is archived
5 Replies Latest reply: Dec 7, 2012 4:09 AM by Osama_Mustafa RSS

DBMS_SCHEDULER

johnnied Explorer
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    check

    http://www.dba-oracle.com/t_dbms_scheduler_cron_shell_scripts.htm
  • 3. Re: DBMS_SCHEDULER
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    http://www.oracle-base.com/articles/10g/scheduler-10g.php
  • 4. Re: DBMS_SCHEDULER
    johnnied Explorer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points