NetIQ Appmanager - Query to find the Stopped job ID’s and the Server names

Below is the SQL query to find the Stopped job ID’s and the Server names in NetIQ AppManager.

select a.Jobid, b.Name from job a, Object b where a.status&0xFF=4 And a.machineobjid = b.objid AND ParentJobID IS NOT NULL AND ParentJobID <> 0

I have customized a KS which event/alerts if there are any stopped jobs and restarts then optionally and it also gives you the server name on which the jobs are stopped. Please contact me if you need the KS.