Thanks for the replies guys, no luck as yet though.

Restarting didn't work, the server never usually gets restarted as it is a production server with several website that are reliant on it, I recently had to move DBs onto a SAN though, which involved the only server restart in well over a year, the old jobs are still there though.

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.