Provides the number of jobs that a schedule is attached to.
Applies to: SQL Server (SQL Server 2008 through current version).
By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted one of the following SQL Server Agent fixed database roles in the msdb database:
For details about the permissions of these roles, see SQL Server Agent Fixed Database Roles.
Only members of sysadmin can view counts for jobs that are owned by others.
The following example lists the number of jobs attached to the NightlyJobs schedule.
USE msdb ; GO EXEC sp_help_jobcount @schedule_name = N'NightlyJobs' ; GO