I'm trying to automatically check for jobs that are in an inactive status and notifying me via e-mail if any are found. I think this can be done using the JOB() variable but can't find the correct parameter. If I use JOB(jobid|NextRun) I get a date/time even if the job is inactivated. I've also tried status and result but can't determine if the job is active or inactive. Any suggestions?
Thanks,
-SP