oracle job 每天执行2次怎么写

Question

 每天凌晨1点和中午13点执行怎么写

    variable job number;

Begin
sys.dbms_job.submit(job => :job,
what => 'Pa_Base_Cartypeset.P_T_If_Dms2P_Pp',
next_date => sysdate,
Interval => 'TRUNC(sysdate) + 1 + 1 / (24)');
commit;
end;
/

Answer 1

根据配置文件配置，

--><!-- 首先是配置你要定时加载的目标类 -->
//在目标类里面写上你调用过程的方法

<!-- 定时器配置 -->
<bean id="timeDitail"
    class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean">
    <property name="targetObject" ref="myTimer"></property><!-- 指定任务类 -->
    <property name="targetMethod" value="doit"></property><!--指定任务方法-->
</bean>

<!-- 定义时间间隔触发器 -->
<bean id="timeTigger" class="org.springframework.scheduling.quartz.CronTriggerBean">
    <property name="jobDetail" ref="timeDitail"></property>
    <property name="cronExpression">
        <value>0 * * * * ?</value>//这个是配置执行的时间点
    </property>
</bean>

 <!-- 启动定时器 -->
<bean id="startJob" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
    <property name="triggers">
        <list>
            <ref bean="timeTigger"/>  
        </list>
    </property>
</bean>