From: Erland Sommarskog on
Mark D Powell (Mark.Powell(a)eds.com) 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)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx