durai nagarajan (5/21/2013)

---

If you are trying to get job status try that data using SysJobHistory table with run_Status.

I'm not just trying to get the status, I'm looking for jobs that are currently running, which the SysJobHistory table doesn't show, this is why I'm looking at sysJobActivity.