Skip to main content

SQL_LinkedServers Job

The SQL_LinkedServers Job identifies Linked Servers or remote database servers on which the identified SQL and Azure SQL servers can execute commands. Some of the common remote OLE DB providers include IBM DB2, Oracle, Access and Excel. Typically, linked servers are used to handle distributed queries in SQL and Azure SQL server .

Analysis Tasks for the SQL_LinkedServers Job​

Navigate to the Databases > Jobs > SQL > 4.Configuration > SQL_LinkedServers Job >Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are pre-configured for this job.

Analysis Selection

The default analysis tasks are:

  • Linked Server Details – Provides details on SQL Linked Servers
  • Linked Server Summary – Summarizes Linked Servers by instance

In addition to the tables created by the analysis tasks, the SQL_DatabaseSizing Job produces the following preconfigured report:

ReportDescriptionDefault TagsReport Elements
Linked ServersThis report highlights Linked Servers where the listed SQL Server is able to execute remote commands.NoneThis report is comprised of three elements: - Bar Chart – Provides information on top five linked servers by instance - Table – Provides details on linked servers by instance - Table – Provides details on linked servers