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.
@kiranragam - Another option could be to have a loading tracking table (a SAS table or a Teradata table) that records when Teradata loads start and end. Then get every SAS job loading into Teradata to update this tracking table.
You can then use the tracking table to check if Teradata is available for loading or not.
Surely Job-A creates a log file. Why not check that file?
@kiranragam - Another option could be to have a loading tracking table (a SAS table or a Teradata table) that records when Teradata loads start and end. Then get every SAS job loading into Teradata to update this tracking table.
You can then use the tracking table to check if Teradata is available for loading or not.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: