调度的脚本
#!/bin/bash
/home/bdss/jdk1.6.0_13/bin/java -jar /home/bdss/ql/T6/v3.100/SqlSchedule/lib/TestSQL-Bbatis.jar "select * from code_month" /home/bdss/ql/T6/v3.100/SqlSchedule/lib/aa 2>/home/bdss/ql/T6/v3.100/SqlSchedule/lib/log
定时任务source一下环境变量(java命令定时任务的时候找不到系统环境变量)
#51 10 31 05 * source /etc/profile&&cd /home/bdss/ql/T6/v3.100/SqlSchedule/lib&&./time.sh 2>/home/bdss/ql/T6/v3.100/SqlSchedule/lib/err
~
~