Try the Query that joins events and actions to find your event... then you can do a similar query to find jobs
Marc
SELECT dbo.tskmst.tskmst_name AS [Action Name], dbo.trgmst.trgmst_name AS [Event Name]
FROM dbo.trgmst INNER JOIN
dbo.trgtsk ON dbo.trgmst.trgmst_id = dbo.trgtsk.trgmst_id RIGHT OUTER JOIN
dbo.tskmst ON dbo.trgtsk.tskmst_id = dbo.tskmst.tskmst_id
WHERE (dbo.tskmst.tskmst_name LIKE '%M011%')