linux定时跑任务(mysql)

定时跑任务：

https://superuser.com/questions/276701/using-the-watch-command-with-an-argument-that-contains-quotes

https://www.tecmint.com/run-repeat-linux-command-every-x-seconds/

 

1. 先把mysql更新命令写成bash script watch_script.sh：

#!/bin/bash

mysql -u root -P 18148 -h 127.0.0.1 -pdeepwise -D deepwise -e "update DW_AI_TASK set task_status=-3 where task_type="CoronaryDiagnose";"

 

(用户 root，端口18148，host 127.0.0.1， 密码deepwise，数据库 deepwise，-e 指令）

 

2. watch -n 300 ./watch_script.sh

每300秒跑一次

 

是否需要在screen中跑？