Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

dbms_scheduler.create_job in type "EXECUTABLE" works only with sysdba role

APEX-DevJun 1 2025

Hello Expers,

I have created an EXECUTABLE job e.g. :

begin
    dbms_scheduler.create_job(
        job_name => 'TEST',
        job_type => 'EXECUTABLE',
        job_action => 'D:\files\TestApp.exe -arg1 100 -logpath D:\files\log',
        enabled => true
    );
end;

When I create this job using the SYS user as sysdba it works but, when I log in using another user with no sysdba role it doesn't work, in spite of, this user has all privileges such as (CREATE ANY JOB & CREATE ANY EXTERNAL JOB).

Any help ?

Thank you.

Comments
Post Details
Added on Jun 1 2025
9 comments
162 views