All,
I am running the below UNIX script to invoke an iBot from Delivers.
. /app/Oracle/OracleBI/setup/sa-init.sh
/app/Oracle/OracleBI/server/Bin/saschinvoke -u administrator/(pwd) -i "/shared/_ibots/SALES/Scheduled iBots - Morning Reports/iBot_04_DM011"
echo $?
I am receiving the following results from ESP spool file...
Success:
----------------------------------------------------------------
Output of messages for workload object DM011_IBOT/OBI_DAILY_MORNING_DISTRIBUTION.64/MAIN
Start date Tue Nov 10 11:01:45 2009
----------------------------------------------------------------
-------------------------------------------------------------------------------
Oracle BI SASchInvoke
Copyright (c) 1997-2006 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------
0
---------------- The end of the file ----------------
Failure:
----------------------------------------------------------------
Output of messages for workload object DM011_IBOT/OBI_DAILY_MORNING_DISTRIBUTION.65/MAIN
Start date Tue Nov 10 11:06:55 2009
----------------------------------------------------------------
-------------------------------------------------------------------------------
Oracle BI SASchInvoke
Copyright (c) 1997-2006 Oracle Corporation, All rights reserved
-------------------------------------------------------------------------------
SASchInvoke Error: No job or more than one jobs found with the same path.
-------------------------------------------------------------------------------
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>])
[-l
[-c <SSL certificate filename>
-k <SSL certificate private key filename>]
[-w <SSL passphrase>|-q <passphrase_file>|-y]
[-h <SSL cipher list>]
[-v
[-e <SSL verification depth>]
-d <CA certificate directory> | -f <CA certificate file>
[-t <SSL trusted peer CNs>]
]
]
-------------------------------------------------------------------------------
0
---------------- The end of the file ----------------
Both are returning an exit code of 0. Since I am running this from ESP it causes the Unix job to complete successfully and continue. Does anyone know another way of going about this? Should Saschinvoke be returning a non-zero exit code when it results in an error?
Any help would be greatly appreciated!!
-Megan