Skip to content

Set Data Collector Job Names

EdVassie edited this page Feb 2, 2021 · 1 revision
Previous Configure MDW Data Collectors Manual Configuration Setup MDW Job Proxy Next

FineBuild can set Data Collector Job Names to make them more meaningful to the DBA.

Configuring the Data Collectors will cause SQL Agent jobs to be created that run the data collection process. These jobs have the data collection number imbedded in the job name, but it is not obvious from the data collection number which data collection set the job relates to.

The jobs are therefore renamed to replace the data collection number with the data collection set name.

FineBuild Set Data Collector Job Names

The configuration of the MDW database within FineBuild is broken down into a number of stages, in order to simplify restart processing if any of them fail.

This section describes how to set the Data Collector Job Names. The Data Collector Job Names configuration relates to Process Id 5EDF.

Top


Manual Set Data Collector Job Names

The following steps show what you would have to do for manual set Data Collector Job Names. FineBuild does all of this work for you automatically.

  1. Use SQL Server Management Studio

    Run the following query to enumerate the collection set Ids

    SELECT collection_set_id,name FROM msdb.dbo.syscollector_collection_sets
    

    SSMS Data Collection

  2. Navigate to the Data Collection jobs

    The names for all these jobs start collection_set. Highlight the first job and select Properties

    Collection Properties

  3. The Job Properties window is displayed

    Job Properties

  4. Change the job name

    Replace the collection set number with the collection set name as shown in the above query

    The table below shows what are normally the correct changes to make, but you should check what has been set up at your own site before making these changes

    Item Name
    Old Name collection_set_1_noncached_collect_and_upload
    New Name collection_set_Disk Usage_noncached_collect_and_upload
    Old Name collection_set_2_collection
    New Name collection_set_Server Activity_collection
    Old Name collection_set_2_upload
    New Name collection_set_Server Activity_upload
    Old Name collection_set_3_collection
    New Name collection_set_Query Statistics_collection
    Old Name collection_set_3_upload
    New Name collection_set_Query Statistics_upload
  5. For each job, also set the Notifications details as shown below:

    Job Notification

  6. Change the Notifications details of the mdw_purge_data_ManagementDW job

    Use the same process as described in step 5.

Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements

Previous Configure MDW Data Collectors Top Setup MDW Job Proxy Next

Key SQL FineBuild Links:

SQL FineBuild supports:

  • All SQL Server versions from SQL 2019 through to SQL 2005
  • Clustered, Non-Clustered and Core implementations of server operating systems
  • Availability and Distributed Availability Groups
  • 64-bit and (where relevant) 32-bit versions of Windows

The following Windows versions are supported:

  • Windows 2022
  • Windows 11
  • Windows 2019
  • Windows 2016
  • Windows 10
  • Windows 2012 R2
  • Windows 8.1
  • Windows 2012
  • Windows 8
  • Windows 2008 R2
  • Windows 7
  • Windows 2008
  • Windows Vista
  • Windows 2003
  • Windows XP
Clone this wiki locally