I want to schedule/Run webi report based on ETL loading.
Once ETL Job finishes successfully, ETL team is creating a table where they are maintaining some flag along with other columns.
suppose flag '0' is success.
based on this flag i want to schedule/run the report.
Can we write some sql to check the status of flag in ETL table..once flag is '0', report should run.
User is not interested for file based event scheduling, because here user need to create some file (may be need to write script)
any other better option you suggest?