🎴 Flashcard Mode
Database Stored Procedures, Triggers, and Job Scheduling
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /
AnswerClick to flip back
A
Job type should be changed to Executable
💡 Explanation:
In Oracle DBMS_SCHEDULER, the parameter job_type must be 'EXECUTABLE' (singular) to run shell scripts. Using 'EXECUTABLES' (plural) is a syntax error, making changing the job type to 'Executable' the necessary modification.