    comments           =>  'PROCESS HIERARCHICAL TAXONOMY');
 END;
 /
+
+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';
+
+
 CREATE OR REPLACE PROCEDURE proc_hierac_tax IS
 	-- note: https://github.com/ArctosDB/arctos/issues/1000#issuecomment-290556611
 	--declare

<cfinclude template="/includes/_header.cfm">

<cfif action is "nothing">
	<cfquery name="mg" datasource="user_login" username="#session.dbuser#" password="#decrypt(session.epw,session.sessionKey)#">
		select distinct (dataset_name) from hierarchical_taxonomy
	</cfquery>

		taxon_name.taxon_name_id=taxon_term.taxon_name_id and
		taxon_term.source='Arctos'
	);




-- unprocessed
select count(*) from temp_ht where scientific_name not in (select TERM from hierarchical_taxonomy);


1402338 rows created.

Elapsed: 00:03:56.85

-- running for 10000 rows...
exec proc_hierac_tax;
00:00:56.33
