sys.sp_help_jobcount
general #stored-procedure
Description
Provides the number of jobs that a schedule is attached to. The identifier of the schedule to list.
Syntax
sp_help_jobcount
[ [ @schedule_name = ]
N
'schedule_name'
]
[ , [ @schedule_id = ] schedule_id ]
[ ; ]