Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Check table availability before running job

We have a daily job that depends on the availability of certain data warehouse tables. Under normal circumstances, the data warehouse table refresh (a process external to my team) is complete before our job runs. On occasion, the DW refresh job runs long, and causes our job to fail when we try to access tables that do not exist.

How would I add a step to the beginning of my job that verifies availability of the required DW tables, and if they are there the job runs; if not, the job should wait x minutes, then try again (up to y times)?

replied

Hello

Add a script that executes SQL to query the tables (or metadata tables) at the start of your job.  You can put the script into a while loop with the sleep function, and drop out after y attempts.

Simple!

Michael

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question