How do I query the database to show a list of stopped jobs? (NETIQKB23065)

How do I query the database to show a list of stopped jobs?

Execute the following SQL statement against the QDB:

select Job.KSName, MachineName=Object.Name

from Job, Object

WHERE Job.MachineObjID=Object.ObjID

AND Job.Status=0x0000004

Formerly known as NETIQKB23065