View Failed Scheduled Jobs in Business Objects XI R2
When I moved from old-school Business Objects (6.x) to XI Release 2 I was happy that the scheduler would now be available for all users directly in WebI, unfortunately along with the improvement came the down-side – no Broadcast Agent Console (BCA Console) to monitor jobs. The lack of an admin tool for the scheduler becomes a pain every now & again since without very careful control you’ll quickly lose track of which documents have been scheduled by whom and whether they’re still running, if they’re failing, etc. Additionally if you experience some sort of system failure (e.g. FRS goes down) you may need to see what failed in order to make sure it is re-run manually.
Well, despite the fact that the CMC doesn’t include a great deal of schedule management functionality, there is a tool bundled with the standard BO installation which can at least help with the issue. The tool is called the Instance Manager and it’s part of the SDK ‘use case’ examples provided and can be accessed via the Administration Launchpad URL as so…
http://bo_server_name:8080/businessobjects/enterprise115/adminlaunch/launchpad.html
… effectively this redirects you to here…
http://bo_server_name:8080/businessobjects/enterprise115/adminlaunch/instancesByStatus/main.jsp
After selecting the Instance Manager on the left-hand menu (see image above), log in with the relevant credentials…
Select the status you want to look for and a username for which you want to search (username optional for everything but ‘All Statuses’) and hit Go!
You then see a list of instances (note, this is Instances not Jobs)…
Please be careful since this screen will allow you to delete instances (up to 100 at a time) if required and whilst there is a message box asking “are you sure you want to delete…” I don’t know of any way to roll back the changes.
[...] a previous post I mentioned previously How to Manage Instances in Business Objects XI R2, well – that’s only half of the story – rather than having to go and delete old [...]
I logged into the CMC as Administrator but don’t know how to get to admin tools or instance manager. Is there a step I am missing or am I missing full rights so I don’t see it?
This is what I see:
ORGANIZE:
Folders, Objects, Groups, Users, Profiles, Server Groups, Servers, Categories, Personal Categories, Inboxes, Universe Connections, Universes
DEFINE: Calendars, Events
MANAGE
Settings, BO Enterprise Apps, License Keys, Authentication
Hi, the Instance Manager isn’t inside the CMC – it’s a different URL from the Administation Launchpad. I’m not sure why I didn’t put the actual URL in the post but I have now, you should be able to access the instance manager directly using this URL…
http://bo_server_name:8080/businessobjects/enterprise115/adminlaunch/instancesByStatus/main.jsp
… having replaced “bo_server_name” with the name of your actual server.
If that doesn’t get you anywhere email me (ash — at — bisql — dot — net).
Thanks for this psost, i was looking for some palce in CMS where you can check the failed jobs and luckily i hit this website .
However i have one question can we arrnage them in ascending order as right now they are randomly arranged.
Hi Anu,
There is a way to do this but you’ll need access to the BO Program Files directory on the server. First you need to find the script, in my (default) installation it was in: C:\Program Files\Business Objects\Tomcat\webapps\businessobjects\enterprise115\adminlaunch\instancesByStatus
Now, take a backup copy of “main.jsp” and then edit the original – in my case I had to edit line 433 but it may differ if you have a slightly different version of XI R2. You need to find the line that says…
compQuery += ” ORDER BY SI_NAME, SI_ID”;
… and change it to read either…
compQuery += ” ORDER BY SI_ENDTIME”;
or
compQuery += ” ORDER BY SI_ENDTIME DESC”;
… depending on whether you want an ascending or descending view (in my view descending is the most useful since it puts the most recent failure at the top).
Hope that helps.
Regards, Ash.
Ash,
Thanks so much. This helped me trace all jkind of jobs.
I ahve another question:
Q: Is there any way to see currently logged in users? Appreciate your help.
Hi, glad to be able to share the little tips I come across! I’ve since decomissioned my XI R2 instance in favour of XI R3 so I can’t dig around myself but I did a little research and came across this possible solution. To quote “TinkerBell” from the BOB forums…
Full URL: http://www.forumtopics.com/busobj/viewtopic.php?t=98950
Cheers, Ash.