Quartz表的创建.docVIP

Quartz表的创建 select * from qtux_job_listeners; select * from qtux_trigger_listeners; select * from qtux_fired_triggers; select * from qtux_simple_triggers; select * from qtux_cron_triggers; select * from qtux_blob_triggers; select * from qtux_triggers; select * from qtux_job_details; select * from qtux_calendars; select * from qtux_paused_trigger_grps; select * from qtux_locks; select * from qtux_scheduler_state; 1311325936964 1311326040000 select * from epma.tux_running_info t order by t.t_r_cdate; delete from qtux_job_listeners; delete from qtux_trigger_listeners; delete from qtux_fired_triggers; delete from qtux_simple_triggers; delete from qtux_cron_triggers; delete from qtux_blob_triggers; delete from qtux_triggers; delete from qtux_job_details; delete from qtux_calendars; delete from qtux_paused_trigger_grps; delete from qtux_locks; delete from qtux_scheduler_state; drop table qtux_calendars; drop table qtux_fired_triggers; drop table qtux_trigger_listeners; drop table qtux_blob_triggers; drop table qtux_cron_triggers; drop table qtux_simple_triggers; drop table qtux_triggers; drop table qtux_job_listeners; drop table qtux_job_details; drop table qtux_paused_trigger_grps; drop table qtux_locks; drop table qtux_scheduler_state; CREATE TABLE qtux_job_details ( JOB_NAME VARCHAR2(200) NOT NULL, JOB_GROUP VARCHAR2(200) NOT NULL, DESCRIPTION VARCHAR2(250) NULL, JOB_CLASS_NAME VARCHAR2(250) NOT NULL, IS_DURABLE VARCHAR2(1) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, IS_STATEFUL VARCHAR2(1) NOT NULL, REQUESTS_RECOVERY VARCHAR2(1) NOT NULL, JOB_DATA BLOB NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP) ); CREATE TABLE qtux_job_listeners ( JOB_NAME VARCHAR2(200) NOT NULL, JOB_GROUP VARCHAR2(200) NOT NULL, JOB_LISTENER VARCHAR2(200) NOT NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER), FOREIGN KEY (JOB_NAME,JOB_GROUP) REFERENCES qtux_JOB_DETAILS(JOB_NAME,JOB_GROUP) ); CREATE TABLE qtux_triggers ( TRIGG