• Have you tried joining on the sysjobs and sysjobschedules tables (on job_id)