Hi Team, As pert of our requirement we need to load a Teradata table(COMMON_TABLE) from multiple SAS Jobs. I am using PROC APPEND (Multiload=YES TPT=YES) to load the data into Teradata table from a sas dataset. While JOB-A is loading data into COMMON_TABLE, JOB-B should wait until the JOB-A passed through the loading step. If I can check the status of a table in a SAS program, I would keep the other jobs running concurrently into multiple sleep intervals and can proceed the execution as soon as the table is available to load. Could you please help me if there is way to check the status of a Teradata table while it is being loaded? I tried below approach before I post the question here: #1. While loading data I noticed a temp table _RS is being created, so I kept the existence check of _RS table before loading and tried to keep the job on sleep until the _RS tables get disappeared. But if the job that is loading data gets failed in between then _RS will remain in the database and other jobs will never get executed until _RS table gets deleted manually.
... View more