Hi,
I run daily SQL reports that tell me which jobs are in an 'unexpected' state. Here's the sample of the code that deals with the scenario that you mention -
/* Selects job icons that are grey and are NOT waiting for input conditions to*/
/* be created from Omniback Unix tables. Also, these jobs are not */
/* dummies and do have memnames (i.e. backups that are waiting on sub time). */
select DESCRIPT AS "Unix Backups outside sub time" from CMR_AJF where SCHEDTAB LIKE '%isobu%' AND STATE = 'B' AND STATUS = 'N' AND TASKTYPE <> 'U' AND MEMNA
ME is not NULL AND HOLDFLAG <> 'D'
ORDER BY DESCRIPT;
Obviously you would need to alter the above to suit your needs. The ctmpsm utility used as a line command would be an alternative way of getting this information.
