How to get a list of reports waiting to be processed

[lordhowe]

We run Seagate Info 7 at a site where up to 900 reports can be run in one day. For management purposes, at anytime we would like to know how many reports are queued waiting to process, that is, what reports are waiting with the status "scheduled".

At the moment, the only thing we seem to be able to do is go through the reports in the folders on the Info Desktop, one at a time, to identify the scheduled reports.

Thanks.

 

[JohnEck]

This could be a bit messy but try setting up a dummy e-mail account and send e-mail notification when the job is scheduled and when the job is completed you should be able to get an idea of what is running. It may clog your mail server but it might work.

 

[JonRob]

You might want to try therunning the query below against your sysem database. Its not 100% accurate and also lists jobs currently processing and recurring jobs that have been scheduled since midnight but it may help. If you can improve it I would be very interested. I tend to use it to see what is processing at the moment, but it should suit your purposes also.

SELECT CINFO75_CI_RUNTIMEIMAGE.CI_MACHINE AS Expr1, CINFO75_CI_RUNTIMEIMAGE.CI_STARTTIME AS Expr2, CINFO75_CI_INFOOBJECTS.CI_NAME AS Expr13, CINFO75_CI_RUNTIMEIMAGE.CI_PARAMETER AS Expr4, CINFO75_CI_RUNTIMEIMAGE.CI_ENDTIME AS Expr5, CINFO75_CI_INFOOBJECTS.CI_NAME AS Expr14, CINFO75_CI_INFOOBJECTS.CI_NAME AS Expr3, CINFO75_CI_INFOOBJECTS_1.CI_NAME AS Expr6
FROM (CINFO75_CI_RUNTIMEIMAGE INNER JOIN CINFO75_CI_INFOOBJECTS ON CINFO75_CI_RUNTIMEIMAGE.CI_REPORTID = CINFO75_CI_INFOOBJECTS.CI_ID) INNER JOIN CINFO75_CI_INFOOBJECTS AS CINFO75_CI_INFOOBJECTS_1 ON CINFO75_CI_INFOOBJECTS.CI_PARENTID = CINFO75_CI_INFOOBJECTS_1.CI_ID
GROUP BY CINFO75_CI_RUNTIMEIMAGE.CI_MACHINE, CINFO75_CI_RUNTIMEIMAGE.CI_STARTTIME, CINFO75_CI_INFOOBJECTS.CI_NAME, CINFO75_CI_RUNTIMEIMAGE.CI_PARAMETER, CINFO75_CI_RUNTIMEIMAGE.CI_ENDTIME, CINFO75_CI_INFOOBJECTS.CI_NAME, CINFO75_CI_INFOOBJECTS.CI_NAME, CINFO75_CI_INFOOBJECTS_1.CI_NAME
HAVING (((CINFO75_CI_RUNTIMEIMAGE.CI_ENDTIME)=Date()))
ORDER BY CINFO75_CI_RUNTIMEIMAGE.CI_STARTTIME DESC;