1.查看定时任务
crontab -l
提示:no crontab for root
crontab -e
后:wq
2.写脚本
#!/bin/bash
source /home/oracle/.bash_profile
DATE=$(date +%Y%m%d)
expdp QH_MIS_BASE/111 directory=DATA_PUMP_DIR dumpfile=QH_MIS_BASE_$DATE.DMP schemas=QH_MIS_BASE
zip /soft/oracle/admin/orcl/dpdump/QH_MIS_BASE_$DATE.zip /zyyd/soft/oracle/admin/orcl/dpdump/QH_MIS_BASE_$DATE.DMP
rm -rf /soft/oracle/admin/orcl/dpdump/QH_MIS_BASE_$DATE.DMP
3.赋权限
$ chmod 777 ./bak.sh
4.
crontab -e
5.
#每天一点半执行
30 1 * * * /zyyd/soft/oracle/bak.sh
其他参考资料:https://blog.csdn.net/by_perseverance/article/details/102369529