Check this post/doc iBot scheduling after ETL load
Is it something you want to run ibots right after etl load? in that case you can use BI itself, but agent run depends on ETL load status. Using W_ETL_RUN_S table as agent condition.
Let me know updates
If helps pls mark :)
oh... based on your post I thought you are using Informatica.
I dont know DS, the Key is let to know to BI about that the load is completed and send agent.
You can go for any kind of approach.
Or else go with given command.
Hope this helps, if does pls mark ;)
There is S_NQ_JOB table in DEV_BIPLATFORM schema which stores the information for each agent and its next runtime in NEXT_RUNTIME_TS column.
You can create a datastage mapping to update this table or insert a new record for your Agent and set the next run time as desired. Schedule this DS mapping at the end of the ETL load.
Edited by: Maqsood Hussain on Oct 26, 2012 8:08 AM