程序如下
[
dbadmin@verdb-77 ~]$ vi hiatory_analyze_statistics.sh
#!/bin/bash
# Program
# This program is for history vertica database ANALYZE_STATISTICS collection,and this program is # run everyday at 1:00.
# History:
# 2015/12/17 dengfafa
vsql -U dbadmin -w *** -d EmBigData -At -F '#' -c "select ANALYZE_STATISTICS('');select now();"
exit 0
程序写好以后注意赋予执行权限
执行计划如下
注意这里设置了exit 0,这里我们可以通过这个判断程序是否执行完,判断方法
[
dbadmin@verdb-77 ~]$ echo $?
0
0