Multiple choice technology databases

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; /

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The job_type parameter must be 'EXECUTABLE' (without the S) for shell scripts, not 'EXECUTABLES'. This typo in the job_type value will cause an error when creating the job.

AI explanation

DBMS_SCHEDULER.CREATE_JOB requires a valid job_type value, and for running an OS shell script the correct value is 'EXECUTABLE' (singular), not 'EXECUTABLES'. Using an invalid job_type string causes the PL/SQL block to raise an error, so the fix is simply correcting the spelling/value of that parameter.

Keep practicing — related questions