fafa1975 wrote:
Hi,
You can query the cmr_ajf table on the Control/M Server database.
SELECT applgroup,nodeid,memname,odate,startrun,endrun,jobname,applic, cast(endrun as bigint) - cast(startrun as bigint) as seconds_elapsed
FROM cmr_ajf order by seconds_elapsed desc LIMIT 10 ;
You can schedule the query just before the NDP and you have the top 10 long running jobs.
Hope it helps.
Fabrizio
Hi,
Can you help out how to set it up on Windows through a bat file with an automated mail
my Controm DB on default PGSQL
I did it on unix with oracel db , but having problem in above environment....
Thanks,
Dablu