system
September 10, 2009, 7:52pm
#1
Hi,
I have some pending jobs showing in the settings area of my CMC. Is there any way of finding which are the pending jobs at once or do we just need to go through the history of all report objects in the system?
Any ideas??
abhi4u (BOB member since 2009-02-11)
system
September 10, 2009, 8:27pm
#2
I think you might have good luck using this utility in the BOB download section:
Instance Lister and Analysis Utility
Atul Chowdhury (BOB member since 2003-07-07)
system
September 10, 2009, 8:46pm
#3
or you can use the following query to get the pending reports
[quote]SELECT top 10000
SI_NAME,
SI_KIND,
SI_SCHEDULEINFO.SI_MACHINE_USED,
SI_SCHEDULEINFO.SI_SCHEDULE_TYPE,
SI_SCHEDULEINFO.SI_OUTCOME,
SI_SCHEDULEINFO.SI_SUBMITTER,
SI_SCHEDULEINFO.SI_STARTTIME,
SI_STARTTIME,
SI_ENDTIME,
SI_SCHEDULE_STATUS
FROM CI_INFOOBJECTS
WHERE
SI_SCHEDULE_STATUS = 9[/quote]
Sree Konduri (BOB member since 2005-07-14)
system
September 10, 2009, 11:18pm
#4
You can use Instance Manager in XI 3.1 CMC to get list of pending jobs.
shekar25 (BOB member since 2004-05-11)