alter schema job

Changes the attributes of an existing schema job.

Syntax

To add a comparison to a schema job:

alter schema job sc_job_name 
add comparison comparison_name
	   With source source_connection_name source_connection_name_alias
   target target_connection_name target_connection_name_alias
		   [and target target2_connection_name target2_connection_name_alias]…
   [include all tables]
         [map tables
     source_connection_name_alias.source_object_schema.source_object_name=
     target_connection_name_alias.target_object_schema.target_object_name[=
     target2_connection_name_alias.target2_object_schema.target2_object_name]…]
     [and source_connection_name_alias.source_object2_schema.source_object2_name=
     target_connection_name_alias.target_object2_schema.target_object2_name[=
     target2_connection_name_alias.target2_object2_schema.target2_object2_name]…]
     ]
          [exclude tables
     source_object_schema.source_object_name
     [and source_object2_schema.source_object2_name]…]

To drop a comparison from a schema job:

alter schema job sc_job_name 
drop comparison comparison_name

To alter a schema comparison that alters its target connection:

alter schema job sc_job_name 
alter comparison comparison_name
drop target target_connection_name
           [and target2_connection_name]…

To alter a schema comparison to add a target connection:

alter schema job sc_job_name 
alter comparison comparison_name
		add target new_target_connection_name new_target_connection_name_alias 
           [and target new_target2_connection_name new_target2_connection_name_alias]… 
[map tables
source.source_object_schema.source_object_name=
new_target_connection_name_alias.new_target_object_schema.new_target_object_name[=
new_target2_connection_name_alias.new_target2_object_schema.new_target2_object_name]…
[and source.source_object2_schema.source_object2_name=
new_target_connection_name_alias.new_target_object2_schema.new_target_object2_name[=
new_target2_connection_name_alias.new_target2_object2_schema.new_target2_object2_name]…]]

To alter a schema comparison to drop table mappings:

alter schema job sc_job_name 
alter comparison comparison_name
drop map  tables 
     source.source_object_schema.source_object_name 
           [and source_connection_name.source_object2_schema.source_object2_name]…

To alter a schema comparison that adds table mappings:

alter schema job sc_job_name 
alter comparison comparison_name
add map tables
source_connection_name.source_object_schema.source_object_name=[
new_target_connection_name.new_target_object_schema.new_target_object_name[=
new_target_connection_name2.new_target_object_schema2.new_target_object_name2]…]]…

Note: The added map entry overrides the existing one, if the key of the new added map entry is included in the existing map.

To alter a schema comparison to add table exclusions:

alter schema job sc_job_name 
alter comparison comparison_name
add map tables
source_connection_name.source_object_schema.source_object_name=[
new_target_connection_name.new_target_object_schema.new_target_object_name[=
new_target_connection_name2.new_target_object_schema2.new_target_object_name2]…]]…

To add an all tables clause to a schema comparison:

alter schema job sc_job_name 
alter comparison comparison_name
add include all tables

To alter a schema comparison to remove the include all tables clause:

alter schema job sc_job_name 
alter comparison comparison_name
drop include all tables

To alter schema comparison job options:

alter schema job sc_job_name 
set max_concurrent_comparisons [{to|=}] number_of_max_concurrent_comparisons
[and set desc [{to|=}] description]

Parameters

sc_job_name – the name of the schema comparison job.
comparison_name – the name of the schema comparison job.
source_connection_name – the name of the source connection.
source_connection_name_alias – the alias name of the source connection.
target_connection_name – the name of the target connection.
target_connection_name_alias – the alias name of the target connection.
source_object_schema – the schema name of the source object.
source_object_name – the name of the source object.
new_source_connection_name – the new name of the source connection.
new_source_object_name – the new name of the source object.
new_source_object_schema – the new schema name of the source object.
target_object_schema – the schema name of the target object.
target_object_name – the name of the target object.
new_target_connection_name – the new name of the target connection.
new_target_object_name – the new name of the target object.
new_target_object_schema – the new schema name of the target object.
max_concurrent_comparisons – the number of maximum concurrent comparisons.
description – description of the agent. Use double quotes if you are using a reserved word or blank spaces.

Examples

Example 1 – disables the include all tables clause in “schema_job”:

alter schema job schema_job
alter comparison sj_cmp
drop include all tables
go

Example 2 – alters the job description for “schema_job”:
```
alter schema job schema_job
set desc="my schema job"
go
```