Question

如何在linux系统中编辑一个脚本，可以自动运行另一个文件夹里的所有脚本？

代码echo "USE 'aisdb'; select * from t41_ais_history where '2013-01-01 00:00:00'<timestamp<'2013-01-02 00:00:00' into file '/data3/bydate/tst/20130101.tsv';" | /opt/hypertable/current/bin/ht shell
echo "USE 'aisdb'; select * from t41_ais_history where '2013-01-02 00:00:00'<timestamp<'2013-01-03 00:00:00' into file '/data3/bydate/tst/20130102.tsv';" | /opt/hypertable/current/bin/ht shell
echo "USE 'aisdb'; select * from t41_ais_history where '2013-01-03 00:00:00'<timestamp<'2013-01-04 00:00:00' into file '/data3/bydate/tst/20130103.tsv';" | /opt/hypertable/current/bin/ht shell
echo "USE 'aisdb'; select * from t41_ais_history where '2013-01-04 00:00:00'<timestamp<'2013-01-05 00:00:00' into file '/data3/bydate/tst/20130104.tsv';" | /opt/hypertable/current/bin/ht shell
我需要使这个脚本自动按顺序运行，请问如何运行。

Answer 1

你写进crontab计划任务就好了，具体操作，百度linux crontab
[root@localhost ~]# cat /etc/crontab
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
HOME=/

# For details see man 4 crontabs

# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * user-name command to be executed

追问

我想写循环语句，执行好一条之后再执行下一条，怎么样才能实现哪？

追答

照着顺序写就行了