I am processing Business Objects reports using custom developed vbscript (Batch Processing script) executed from SysAdmiral.
The sysadmiral job will execute the script and connect to the BO server
After establishing the connection I get the report list from the database and process the reports based on a set of actions defined in the database for each report. eg save as HTML
Now I want to handle any type of network error that occurs while the script is executing.
I want that my script should
1. Exit the application.
2. Wait for 3 seconds.
3. Start the script from the beginning.
a. Read environment variables
b. Reconnect to repository
c. Read application settings from the database.
d. Fetch reports matching Batch Id and Report Id from the database
e. Perform required actions for every report in the list.
If there is an error during executing step 2 then repeat these steps again up to 3 times. After the 3-d attempt exit and send email to Applications Support.
Please help its very urgent
Thanks in advance
Rachit
The sysadmiral job will execute the script and connect to the BO server
After establishing the connection I get the report list from the database and process the reports based on a set of actions defined in the database for each report. eg save as HTML
Now I want to handle any type of network error that occurs while the script is executing.
I want that my script should
1. Exit the application.
2. Wait for 3 seconds.
3. Start the script from the beginning.
a. Read environment variables
b. Reconnect to repository
c. Read application settings from the database.
d. Fetch reports matching Batch Id and Report Id from the database
e. Perform required actions for every report in the list.
If there is an error during executing step 2 then repeat these steps again up to 3 times. After the 3-d attempt exit and send email to Applications Support.
Please help its very urgent
Thanks in advance
Rachit
