Basic Cron job not working in UBUNTU

blueeyesblue

I have a file named query.sql inside which I have 2 lines as follows:

---------------------------------------------------------------------
connect to test;
select * from DF_MOVIE_MOVIE where movieid=10;

--------------------------------------------------------------------

In crontab I have the following line:

-----------------------------------------------------------------------
32 15 * * * db2 -tvf '/home/db2inst1/query.sql' > a.out
-----------------------------------------------------------------------


If I run db2 -tvf '/home/db2inst1/query.sql' > a.out outside crontab, it runs fine and produces the output in a.out.....When I run it from crontab it only produces and empty a.out file at the specified time.

Can anyone help me out please?

Aug 31 '07 #1

docdiesel

Hi,

In crontab I have the following line:
-----------------------------------------------------------------------
32 15 * * * db2 -tvf '/home/db2inst1/query.sql' > a.out
-----------------------------------------------------------------------

Make that

When running from crontab, the DB2 environment is missing. Setting it by premitting a ". ~/.profile" should fix this.

Regards, Bernd

Aug 31 '07 #2