home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.ingres
- Path: sparky!uunet!psinntp!panix!coop
- From: coop@panix.com (Robert Cooper)
- Subject: Re: Running Ingres using Unix Cron
- Message-ID: <C0rv1G.JqH@panix.com>
- Keywords: Ingres Cron
- Organization: PANIX Public Access Unix, NYC
- References: <1993Jan12.163830.17691@zia.aoc.nrao.edu>
- Date: Wed, 13 Jan 1993 03:00:52 GMT
- Lines: 27
-
-
-
- >I have been trying to run an Ingres report using the unix Cron
- >facility so that some report files can be automatically updated on a
- >daily basis. I use the report <database> <reportname> feature of
- >ingres inside of an executable unix script. If I run this script
- >manually it works correctly. If I set this up as a Cron job it does
- >not work even when I preface all files with appropriate paths. Since
- >others have had problems making ingres programs (e.g. embedded SQL and
- >4GL) run under Cron I wanted to find out if there is a way to make
- >this feature work. If the job cannot be run automatically the
- >usefulness of the ingres report writer goes to zero in this
- >application. I would appreciate any help on this matter. Thankyou.
-
- >Carl Bignell
-
-
- Cron uses a very limited path when it runs. Ingres needs to find other
- files in its bin directory. At the top of your shell script you need
- to include the ingres/bin directory to the default cron path.
-
-
- --
- Robert Cooper Brooklyn, NY | "We have to learn to manage information and
- coop@panix.com | its flow. If we don't, it will all end up
- 212 309-9600 (Work) | in turbulence." Grace Hopper
-
-