Hi all, I have a simple problem.

[Guest_imported]

Hi all,
I have a simple problem. We are working in a datawarehousing environment, and the daily tables are created anytime between 12am - morning. As part of our automation initiative, we decided to automatically run the programs at a pre-set time using the 'wakeup' function. It works fine for the first couple of months, but now, as the number of programs grew, this no longer suffice. We need to start the programs immediately after the tables are ready. We have designed a program to get the list of table names. Now, how do I write a code that does something like:

do
{
If (table name exist in recent output) exit
} while

 

[cruel]

I have used shell script to do a similar job before. You can use [! -f filename] to check if the table has been created, if so than run the sas job. Use crontab to run the job after noon. Hope it helps.