How to schedule vsql command from cron job ?

[verticatest]

Hi,

I have created a file say testquery and when I am running this executable file ./testquery , it is executing perfectly , that is connecting to database and inserting a new record.However, when I am scheduling the same file using cron job it is failing with the error msg : vsql command not found.

Following is the two lines of code in that file (testquery):

cd /opt/vertica/bin/
vsql -d dbname -c "insert into testtable values(100,'aaa',200);commit;" -U dbadmin -w test



Plz help me in resolving this issue.


Thanks
martyn

[JimKnicely]

Instead of changing the directory, can you use the full path to vsql like this?

/opt/vertica/bin/vsql -d dbname -c "insert into testtable values(100,'aaa',200);commit;" -U dbadmin -w test

[verticatest]

Thanks a ton "knicely87", it worked.


Thanks again
Martyn