[postgresql] execute function in shell using crontab

1. register the account information

vi ~/.pgpass
localhost:portnumber:db_name:username:password

2. create shell script

vi shell.sh

#!/bin/sh

dbname="dbname"
username="username"

/opt/postgres/9.3/bin/psql $dbname $username<<EOF
select function_name();
EOF

3. register into the crontab

*/1 * * * * /home/shell/shell.sh > /log/errlog.log 2>&1

[altibase]execute altibase procedure every 1 minute using crontab

export ALTIBASE_HOME='/altibase/altibase_home'
export PATH=./:$PATH

ISQL="/altibase/altibase_home/bin/isql -s localhost -u user-p pass-port 20300"

${ISQL} << EOF
        exec PROC_NAME;
        quit
EOF

[linux] when crontab does not working

1. use absolute path
2. check error message using following script
1. */1 * * * * /test/test.sh > /tmp/test.log 2>&1
3. set environmet variable in the script file

when crontab not working

when crontab not working

1. check cron log
1. /var/log/cron
2. check mail and find the error and correct the error
1. /var/spool/mail/userId