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
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
