MapperScheduler.xml

(job_name,

trigger_id,

trigger_type,

trigger_expression,

created_by,

created_date,

updated_by,

updated_date)

values(

#{job_name, jdbcType = VARCHAR},

#{trigger_id, jdbcType = VARCHAR},

#{trigger_type, jdbcType = NUMERIC},

#{trigger_expression, jdbcType = VARCHAR},

#{created_by, jdbcType = VARCHAR},

sysdate,

#{created_by, jdbcType = VARCHAR},

sysdate

)

insert into DA_QRTZ_LOG

(

job_name,

trigger_id,

start_time,

end_time,

seconds_costed,

created_by,

created_date,

updated_by,

updated_date)

values(

#{job_name, jdbcType = VARCHAR},

#{trigger_id, jdbcType = VARCHAR},

#{start_time, jdbcType = TIMESTAMP},

#{end_time, jdbcType = TIMESTAMP},

#{seconds_costed, jdbcType = VARCHAR},

#{created_by, jdbcType = VARCHAR},

sysdate,

#{created_by, jdbcType = VARCHAR},

sysdate

)

delete from da_qrtz_scheduler where trigger_id = #{trigger_id, jdbcType = NUMERIC}