创建定时任务http://www.cndba.cn/hbhe0316/article/4775

[db2inst1@db01 ~]$ db2 -v "CALL SYSPROC.ADMIN_TASK_ADD ('TEST1', CURRENT_TIMESTAMP, NULL, NULL, '10 * * * *', 'SYSPROC', 'ADMIN_CMD', 'VALUES(''export to /home/db2inst1/t1.del of del messages on server select * from t1'')', NULL, NULL )"
CALL SYSPROC.ADMIN_TASK_ADD ('TEST1', CURRENT_TIMESTAMP, NULL, NULL, '10 * * * *', 'SYSPROC', 'ADMIN_CMD', 'VALUES(''export to /home/db2inst1/t1.del of del messages on server select * from t1'')', NULL, NULL )
  Return Status = 0

查看定时任务http://www.cndba.cn/hbhe0316/article/4775http://www.cndba.cn/hbhe0316/article/4775

[db2inst1@db01 ~]$ db2 -v "select char(name, 20) as Name, begin_time, end_time, char(schedule, 20) as Schedule from systools.admin_task_list"
select char(name, 20) as Name, begin_time, end_time, char(schedule, 20) as Schedule from systools.admin_task_list

NAME                 BEGIN_TIME                 END_TIME                   SCHEDULE            
-------------------- -------------------------- -------------------------- --------------------
TEST1                2020-05-15-17.00.28.541459 -                          10 * * * *          

  1 record(s) selected.

信息中心文档：
https://www.ibm.com/support/pages/db2-luw-sample-administrative-task-schduler-admintaskadd-and-admintaskremove-usagehttp://www.cndba.cn/hbhe0316/article/4775http://www.cndba.cn/hbhe0316/article/4775http://www.cndba.cn/hbhe0316/article/4775http://www.cndba.cn/hbhe0316/article/4775

版权声明：本文为博主原创文章，未经博主允许不得转载。

Linux,oracle