sp_help_jobcount (Transact-SQL)

Applies to: SQL Server

Provides the number of jobs that a schedule is attached to.

Transact-SQL syntax conventions

Syntax

sp_help_jobcount
    [ [ @schedule_name = ] N'schedule_name' ]
    [ , [ @schedule_id = ] schedule_id ]
[ ; ]

Arguments

[ @schedule_id = ] schedule_id

The identifier of the schedule to list. @schedule_id is int, with no default.

Either @schedule_id or @schedule_name can be specified.

[ @schedule_name = ] N'schedule_name'

The name of the schedule to list. @schedule_name is sysname, with no default.

Either @schedule_id or @schedule_name can be specified.

Return code values

0 (success) or 1 (failure).

Result set

Returns the following result set:

Column name Data type Description
JobCount int Number of jobs for the specified schedule.

Remarks

This procedure lists the number of jobs attached to the specified schedule.

Permissions

This stored procedure is owned by the db_owner role. You can grant EXECUTE permissions for any user, but these permissions may be overridden during a SQL Server upgrade.

Other users must be granted one of the following SQL Server Agent fixed database roles in the msdb database:

  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

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.

Examples

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