count schema job

Syntax

count schema job [job_name [comparison_name]]

Parameters

• job_name – specifies the schema job name with optional wildcards to count subsets of schema jobs.
• comparison_name – specifies the comparison name with optional wildcards to count subsets of comparisons.

Examples

• Example 1 – counts all schema jobs with names that begin with test:

  count schema job test*
  go
  
  COUNT
  -----
  6
  
  (0 rows affected)

• Example 2 – counts all comparisons in the schema job schjob4 that have names that end with x:

  count schema job schjob4 *x
  go
  
  COUNT
  -----
  1
  
  (0 rows affected)