begin
sys.dbms_scheduler.create_job(job_name            => 'URSCHEMA.URJOBNAME',
job_type            => 'EXECUTABLE',
job_action          => '/home/user/dir1/urshellscript.sh',
start_date          => TRUNC(SYSDATE) + 12/24,
repeat_interval     => 'Freq=Daily;Interval=1',
end_date            => to_date(null),
job_class           => 'DEFAULT_JOB_CLASS',
enabled             => FALSE,
auto_drop           => false,
comments            => 'This job executes an external script');
dbms_scheduler.set_attribute('URSCHEMA.URJOBNAME', 'credential_name', 'OWNEROFCRED.CREDENTIALNM');
dbms_scheduler.enable('URSCHEMA.URJOBNAME');      
end;
/
A blog to help me remember what in the hell i've done and what not to do again. ever. Maybe you'll learn from my mistakes or epiphanies. Blog topics include SQL, T-SQL, Google, Windows, Visual Basic, Python, C#, etc.
Wednesday, February 16, 2011
DBMS_SCHEDULER External Job with credentials
To avoid scheduler error: ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied make sure and add a credential to any DBMS_SCHEDULER job that is executing external code (e.g. shell script).
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment