Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Rule name

DB tables reference are fully qualified

Parallel Job

Yes

Server Job

Yes

Job Sequence

-

Description

Identifies where database table references are not fully-qualified

Description

Database table references can sometimes cause problems when migrating from Development to downstream QA and Production environments as they will likely be communicating with different databases to those used in Development. Those databases may well have different configurations to those against which the Job was developed, and there may arise some confusion about which schemas or other database objects are being referenced by the Job.

Actions

Ensure all database object references used by your Job are fully qualified (e.g. {schema}.{tablename})

  • No labels