Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 20 Dec 2013 @ 13:46:23 GMT


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


Subj:   Re: Queue Tables
 
From:   Khongthaw, Raja

Hi David,

My thought:

I did not check if Teradata job scheduler can do this functionality.

Your procedure may run for short, medium, long hours :).

So what I think is run a unix script continuous for some hours you need, using "wait" and sniff the arrival of a file Redirected from a query maybe in a particular directory.

Once the file arrives, then start processing. Have one control table, that logs the status of completion (R,C etc) So that next time when the queue comes, it checks this control table. If the proc is still running, don't start The process of landing sniffer file. Once the stored proc is completed, then check the arrival of the sniffer file Again.

I don't know if I explain it clearly or not.


Regards,

Raja



     
  <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: 24 Jul 2020