Getting Job Info

Hi,
Is there a stored procedure which will return all jobs on a server along
with their current status (I am especially interested in getting back the
Last Run Status)? If not, does anybody have a query that would do this?
I need to run this on SQL Server 7 and 2000.
Thanks,
James
Check out sp_help_Job in BooksOnLine.
Andrew J. Kelly SQL MVP
"JW" <nospam@.hotmail.com> wrote in message
news:uwDnmtPNEHA.3096@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there a stored procedure which will return all jobs on a server along
> with their current status (I am especially interested in getting back the
> Last Run Status)? If not, does anybody have a query that would do this?
> I need to run this on SQL Server 7 and 2000.
> Thanks,
> James
>