Saturday, March 5, 2016

Stored Procedure script to show all jobs

USE [master]
GO

create proc [dbo].[sp_ShowJobs]
as
SELECT
j.name AS 'Job', *
FROM msdb.dbo.sysschedules sched
JOIN msdb.dbo.sysjobschedules jsched ON sched.schedule_id = jsched.schedule_id
JOIN msdb.dbo.sysjobs j ON jsched.job_id = j.job_id

GO


No comments :