From: Erland Sommarskog on
Mark D Powell (Mark.Powell(a) writes:
> Looking over the list of job tables and then looking at the
> documentation it would seem that the sysjobactivty table would provide
> my answer however the table has 4751 rows and many of the jobs have
> not ran since 2008 so obviously there is more to understanding the
> table contents

I don't work that much with the msdb tables, so I don't have any
ready recipe for you. But what happens if you join in sysjobs, and
filter out disabled jobs?

Erland Sommarskog, SQL Server MVP, esquel(a)

Links for SQL Server Books Online:
SQL 2008:
SQL 2005:
SQL 2000: