Dbms scheduler jobs, programs and schedules - Revision history

Stuart: /* Create a scheduled job */

2016-07-26T16:48:44Z

‎Create a scheduled job

2013-02-01T12:45:18Z

2013-02-01T12:44:53Z

2013-02-01T11:10:07Z

New page

* [[http://www.oracle-base.com/articles/10g/scheduler-10g.php Some useful queries]]

@@ Line 11: / Line 11: @@
 </pre>
 ===Run a scheduled job===
 <pre>
 execute dbms_scheduler.run_job('xxxTOOLS.REBUILD_VIEW_ALL_RMANS');
 </pre>

@@ Line 13: / Line 13: @@
 ===Run a scheduled job===
 <pre>
-execute dbms_scheduler.run_job('IBMTOOLS.REBUILD_VIEW_ALL_RMANS');
+execute dbms_scheduler.run_job('xxxTOOLS.REBUILD_VIEW_ALL_RMANS');
 </pre>

← Older revision		Revision as of 12:44, 1 February 2013
Line 1:		Line 1:
	* [[http://www.oracle-base.com/articles/10g/scheduler-10g.php Some useful queries]]		* [[http://www.oracle-base.com/articles/10g/scheduler-10g.php Some useful queries]]
		+
		+	===Create a scheduled job===
		+	<pre>
		+	DBMS_SCHEDULER.CREATE_JOB( job_name => 'rebuild_view_all_rmans'
		+	, job_type => 'STORED_PROCEDURE'
		+	, job_action => 'create_all_rmans.rebuild_view'
		+	, repeat_interval => 'FREQ=DAILY;BYHOUR=8;BYMINUTE=0;BYSECOND=0'
		+	, enabled => TRUE
		+	, comments => 'Rebuild view ALL_RMANS');
		+
		+	</pre>
		+	===Run a scheduled job===
		+	<pre>
		+	execute dbms_scheduler.run_job('IBMTOOLS.REBUILD_VIEW_ALL_RMANS');
		+	</pre>