Stored Proc to list all Scheduled Jobs ?

[JohnBates]

Hi -

I am using SQL Server 7.

Does anyone know of a System stored procedure that displays (or prints) scheduled jobs... the jobs that can be defined in SQL Server Agent ? I could probably write my own but why reinvent the wheel...

and a related question : How can I get a list of ALL the system-supplied stored procedures and what each does?

Thanks, John

 

[tlbroadbent]

Use the system stored procedure sp_help_job.

SQL BOL is a great resource for learning these things. Look under the topic, "System Stored Procedures (T-SQL)" for more great info. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.