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