 
 
 
+BEGIN
+DBMS_SCHEDULER.DROP_JOB('J_PROC_HIERAC_TAX_NC');
+END;
+/
+
+BEGIN
+DBMS_SCHEDULER.CREATE_JOB (
+   job_name           =>  'J_PROC_HIERAC_TAX_NC',
+   job_type           =>  'STORED_PROCEDURE',
+   job_action         =>  'proc_hierac_tax_noclass',
+   start_date         =>  SYSTIMESTAMP,
+	repeat_interval    =>  'freq=minutely; interval=3',
+   enabled             =>  TRUE,
+   end_date           =>  NULL,
+   comments           =>  'PROCESS HIERARCHICAL TAXONOMY (noclassification)');
+END;
+/
 
 exec proc_hierac_tax_noclass
 
+select STATE,LAST_RUN_DURATION,MAX_RUN_DURATION,LAST_START_DATE,NEXT_RUN_DATE from all_scheduler_jobs where JOB_NAME='J_PROC_HIERAC_TAX';
+select STATE,LAST_RUN_DURATION,MAX_RUN_DURATION,LAST_START_DATE,NEXT_RUN_DATE from all_scheduler_jobs where JOB_NAME='J_PROC_HIERAC_TAX_NC';
 
 
 

	/
sho err;

CREATE OR REPLACE PROCEDURE proc_hierac_tax_noclass IS
begin



</cfif>


<cfif action is "deleteDataset">
	<cfoutput>
