Archives of the TeradataForum
Message Posted: Tue, 05 Dec 2006 @ 14:18:12 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|