This discussion is archived
6 Replies Latest reply: Jul 26, 2013 12:03 AM by User7292 RSS

DBMS_SCHEDULER RUN_JOB succeded but nothing happens

User7292 Newbie
Currently Being Moderated

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.

Legend

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