OITSQ03-UPROD1 (Obsolete)

Owned by Mark Young
Last updated: May 22, 2023 by Alexis Wall (Deactivated)

Description

OITSQ03-UPROD1 is the Report Server for the legacy SUDDS data warehouse. In addition, it hosts some SSIS Jobs.

** This server is no longer being used and could be retired.

Status

5/22/2023 - Server Windows OS upgraded

Artifacts on SQL03-UPROD1

  1. Scheduled Jobs - none

  2. Databases

  3. SQL Agent Jobs

    1. ADImport - import SSIS job for Advisor Planner - source server is the server OITSQ206, which doesn’t exist

    2. ADExport - export SSIS job for Advisor Planner

    3. ColleagueSecurity - manipulates the OIT_ColleagueSecurity databases on OITSQ001 OITSQ01-PROD, and OITSQ002, and files on OITSQ001

  4. Shares

    1. M → M:\

  5. Linked Servers

    1. There is a linked server to OITDW1