This content has been marked as final. Show 4 replies
Hi Sandeep,1 person found this helpful
You have a couple of options here, the conditional request route, or simply calling the ibot execution from the command line.
For the conditional request, I'd set up an RPD init block that retrieves the ETL date into a variable.
You then set up a simple answers request to return a row (for example from the time dimension) when the ETL date is greater than or equal to today (e.g the ETL has refreshed)
This report then forms the conditional request for the ibots, if the conditional request returns a row, the ibots are executed.
The alternative for command line execution , uses the 'saschinvoke' which is Siebel Analytics Scheduler Invoke. :
Usage: SASchInvoke.exe -u <Admin Name>/<Admin Password>
(-j <job id> | -i <iBot path>)
([-m <machine name>[:<port>]]
| -p <primaryCCS>[:<port>] -s <secondaryCCS>[:<port>])
([(-r <replace parameter filename>
|-a <append parameter filename>)]
| [-x <re-run instance id>])
[-c <SSL certificate filename>
-k <SSL certificate private key filename>]
[-w <SSL passphrase>|-q <passphrase_file>|-y]
[-h <SSL cipher list>]
[-e <SSL verification depth>]
-d <CA certificate directory> | -f <CA certificate file>
[-t <SSL trusted peer CNs>]
Hope this helps,
Thanks for this useful post.It cleared many doubts.I have one small doubt.It might be a stupid question.But this is the first time i am creating an ibot.The question is if i put a conditional request in place and in the Ibot deliver section i check 'start immediately' then will it deliver ibot only once in that day when my request returns row or it will keep on sending the Ibots.
As i understand, 'Start immediately' is merely the starting point, you need to set the 'Recurrance' options, 'Repeat every' etc to get it to repeat.
Hope this helps, if useful please award some points !
Thanks.It solved the problem.