Archives of the TeradataForum

Message Posted: Tue, 05 Dec 2006 @ 14:18:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi everybody

We have two macros that are run from cron jobs. One that drops join indexes before our ETL loads, and the other that re-creates the join indexes after our loads. The create join index macro is always successful. The drop join index macro runs successfully when submitted as a batch bteq script, however the same bteq script fails when run as a cron job.

The error message returned is:

     Failure 3807 Object 'location' does not exist.
     Statement# 1, Info =104

Does anyone have any experience with this? Does anyone have any ideas?

Thanks in advance

	<Prev	Next>		<<First	<Prev	Next>	Last>>