计划任务at

1

systemctl status atd 
systemctl restart atd 

计划任务at

 sql]# date 
2021年 10月 29日 星期五 17:46:48 CST
[root@beta-insurance sql]# at  17:52 
at> bash /data/tmp/sql/1.sql
at> 
at> 
at> <EOT>
job 1 at Fri Oct 29 17:52:00 2021





[root@rpmbuild data]# /etc/init.d/atd start
正在启动 atd： [确定]
[root@rpmbuild data]# date
2015年 05月 08日 星期五 20:20:34 CST
[root@rpmbuild data]# at 02:00 2015-05-09
at> poweroff
at>
job 3 at 2015-05-08 20:23
root@localhost ~] # cat /tmp/ps.root //等过了计划时间后验证结果
63 //显示的进程数
例：设置当天17:30自动关闭当前系统
[root@localhost ~] # at 17:30
at> shutdown -h now
at>
查询当前系统中设置的at计划任务列表
[root@localhost ~] # atq
删除指定任务编号的at任务
[root@localhost ~] # atrm 2 （删除前使用atq查询一下编号）
















458M	client
4.4G	common
26G	manage
6.6G	optimize
4.3G	proxy
63G	service
46M	source
97M	sscf


/backup/cfb-env-back.sh

mysqldump -ucfbapp -p -h cfb.mysql.server --all-databases > /backup/db/cfb/all_database_`date +"%Y%m%d%H%m"`.sql


proxy-core.2239.com


1.2G	cfyf-crm-project
23M	cfyf-money-manage
2.2G	cfyf-service-project
159M	cfyf-trd-service
55M	cfyf-trd-service-bak
77M	sscf-crm-client
1.4G	sscf-crm-project


for loop in `ls`
do
echo >$loop
done



/Users/rico/Documents/cfb-docker-script-master/cfb-centos/data/nginx/service/core-service/www/service.core.sscf.com/app/Modules/Management/Business/Policy


SELECT
 count( 1 ) AS '包含供应商产品数' 
FROM
 product UNION ALL
SELECT
 count( 1 ) AS '包含供应商产品数' 
FROM
 cps_branch_product a LEFT JOIN cps_product b ON a.cps_product_id = b.id
WHERE
 a.add_time < 1635350400 AND b.supplier_id > 0 and a.deleted_at is null;