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 to be shown.
schema_job_comparison_name – the name of the schema comparison to be shown.

Examples

Example 1 – shows existing schema jobs, with their status:

show schema job
go

The returned result is:

Name         Active   Description
------      --------  ------------
scjob_1      true     my_schemajob1
scjob_2      true     my_schemajob2
scjob_3      true     my_schemajob3