PL/SQL (MOSC)

MOSC Banner

Getting Eror while executing SCHEDULDER JOBS

edited Apr 2, 2012 9:55AM in PL/SQL (MOSC) 5 commentsAnswered
Hello All

Getting error while execution the below scheduler

BEGIN
  dbms_scheduler.create_job(
  job_name   => 'DAILY_LOAD',
  job_type   => 'EXECUTABLE',
  job_action => '/orabin/sfcm/oracle/scripts/appjob_load_trk_alert.ksh',
  enabled => true,
  comments   => 'To send alert mail for Daily Load');
END;
/

begin
dbms_scheduler.run_job('DAILY_LOAD');
end;
/

ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2

Running from Oralce 11.2.0

Os: HP Solaris

Granted executable privileges to the running schema

Can anyone suggest me on this, and please share any documents also

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center