31-1:
	BEGIN
	  DBMS_SCHEDULER.CREATE_JOB (
	   job_name           =>  'collect_scott',
	   job_type           =>  'PLSQL_BLOCK',
	   job_action         =>  'BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(''SCOTT''); END;',
	   repeat_interval    =>  'FREQ=DAILY;INTERVAL=1'
	  );
	END;
	/
31-2:
	EXEC DBMS_SCHEDULER.RUN_JOB('collect_scott')
31-3:
	exec DBMS_SCHEDULER.DROP_JOB('collect_scott')
31-4:
	EXEC DBMS_SCHEDULER.DISABLE('collect_scott')
	EXEC DBMS_SCHEDULER.ENABLE('collect_scott')
31-5:
	BEGIN
	  DBMS_SCHEDULER.CREATE_PROGRAM (
	   program_name           => 'program1',
	   program_action         => 'BEGIN dbms_stats.gather_table_stats(''SCOTT'',''DEPT''); END;',
	   program_type           => 'PLSQL_BLOCK'
	  );
	END;
	/
31-6:
	EXEC DBMS_SCHEDULER.DROP_PROGRAM('program1')
31-7:
	EXEC DBMS_SCHEDULER.DISABLE('program1')
	EXEC DBMS_SCHEDULER.ENABLE('program1')
31-8:
	BEGIN
	  DBMS_SCHEDULER.CREATE_JOB (
	   job_name           =>  'job1',
	   program_name       =>  'program1'
	  );
	END;
	/
	EXEC DBMS_SCHEDULER.RUN_JOB('job1')
31-9:
	BEGIN
	  DBMS_SCHEDULER.CREATE_SCHEDULE (
	    schedule_name     => 'schedule1',
	    start_date        => SYSTIMESTAMP,
	    end_date          => SYSTIMESTAMP + INTERVAL '30' day,
	    repeat_interval   => 'FREQ=HOURLY; INTERVAL=4'
	  );
	END;
	/
31-10:
	exec DBMS_SCHEDULER.DROP_SCHEDULE('schedule1')
31-11:
	BEGIN
	  DBMS_SCHEDULER.CREATE_JOB (
	    job_name           => 'job2',
	    program_name       => 'program1',
	    schedule_name      => 'schedule1'
	  );
	END;
	/
31-12:
	BEGIN
	  DBMS_SCHEDULER.CREATE_JOB_CLASS (
	   job_class_name             =>  'class1',
	   resource_consumer_group    =>  'group1');
	END;
	/
31-13:
	EXEC DBMS_SCHEDULER.DROP_JOB_CLASS('class1')
31-14:
	BEGIN
	  DBMS_SCHEDULER.CREATE_JOB (
	    job_name           => 'job3',
	    program_name       => 'program1',
	    job_class          => 'class1'
	  );
	END;
	/
31-15:


