Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Drop Join Index Macro Fails As Cron Job
 
From:   PryorCh

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016