Archives of the TeradataForum
Message Posted: Fri, 20 Dec 2013 @ 13:46:23 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|