show schema job

Shows zero or more existing schema comparison jobs, each of which consists of one or more comparisons.

Syntax

show schema job [schema_job_name [schema_job_comparison_name]]

Parameters

schema_job_name – the name of the schema comparison job with optional wildcards.
schema_job_comparison_name – the name of the schema comparison with optional wildcards.
Note: You cannot use wildcard characters in schema_job_name when you specify a schema_job_comparison_name.

Examples

Example 1 – shows schema job names that begin with "sc":

show schema job sc*
go

The returned result is:

NAME       ACTIVE   DESCRIPTION
---------- -------- --------------------------------------
scjob_cust true     Compares the tables in the customer db
scjob_bo   true     Compares the back office tables