Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER RUN_JOB succeded but nothing happens

User7292Jul 24 2013 — edited Jul 26 2013

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.

This post has been answered by Mihael on Jul 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2013
Added on Jul 24 2013
6 comments
3,511 views