6 Replies Latest reply: Jul 26, 2013 2:03 AM by User7292 RSS

    DBMS_SCHEDULER RUN_JOB succeded but nothing happens

    User7292

      Hi all,

       

      I'm working on a project where I have to create an URL and open it.

      The creation of the URL works fine.

      To open it in a Browser, I tried to create a job in the dbms_scheduler:

       

      Begin

      Dbms_Scheduler.Create_Job(

        Job_Name=>'IE',

        Job_Action=>'/bin/ksh',

        Number_Of_Arguments=>2,

        enabled=>false,

        Job_Type=>'executable');

        Dbms_Scheduler.Set_Job_Argument_Value('IE',1,'#!/Bin/ksh' );

        Dbms_Scheduler.Set_Job_Argument_Value('IE',2,'elinks "URL" ' );

      End;

       

      this works fine,too.

      But when I now want to run the Job the code succeeds but nothing happens.

      The commands should open a Browser with the given URL. If this works fine, an E-mail is send to a specific address.

      The URL opens the BirtMailer, a tool to send reports as E-mail attachments.

      If I run the command on the shell everything works fine and the E-mail is sent. But with the Scheduler nothing happens.

       

      Any suggestion or advice will be apreciated.

      Thanks to all.