Showing SQL for a Scheduler Job

Previous

Next

To view the SQL statements for a specific Scheduler Job:

1. On the Scheduler Jobs page, select a job from the list.

2. Click Edit Job Definition.

   The Edit Job Definition page appears for the selected job.

3. Click Show SQL.

   The SQL statements for the selected job definition appear.

Example of Show SQL Output for a Job Definition

BEGIN
sys.dbms_scheduler.create_job( 
job_name => '"ROGER"."TEST JOB"',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
CTX_DDL.OPTIMIZE_INDEX(''ROGER.FILES11_INDEX'',''FULL'');
 
END;
',
start_date => systimestamp at time zone '-7:00',
job_class => '"DEFAULT_JOB_CLASS"',
comments => 'Text Index Job Submitted by EM',
auto_drop => FALSE,
enabled => FALSE);
sys.dbms_scheduler.set_attribute( name => '"ROGER"."TEST JOB"', attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF); 
sys.dbms_scheduler.set_attribute( name => '"ROGER"."TEST JOB"', attribute => 'job_weight', value => 1); 
END;