Recommended Configuration for the Redshift Solution
The Redshift Solution is configured to inherit settings from the global Settings node. However, it is best practice to assign the host list and the Connection Profile at the data collection level, the 0.Collection Job Group. After these are assigned to the job group, it can be run directly or scheduled.
Dependencies
This job group doesn't have dependencies.
Targeted Hosts
The Redshift Job Group has been configured to inherit the host list assignment from the collection group level.
Assign the host list under the Redshift > 0.Collection > Settings > Host List Assignment node. The Local host box is checked by default.
Connection Profile
The SQL Data Collector requires a specific set of permissions. See the Permissions section for necessary permissions. The account used can be either an Active Directory account or a SQL account. After the account has been provisioned, create a custom Connection Profile containing the credentials for the targeted environment. See the SQL Custom Connection Profile & Default Dynamic Host List topic for additional information.
Assign the Connection Profile under the Redshift > 0.Collection > Settings > Connection node. It is set to Use the Default Profile, as configured at the global settings level. However, since this may not be the Connection Profile with the necessary permissions for the assigned hosts, click the radio button for the Select one of the following user defined profiles option and select the appropriate Connection Profile dropdown menu.
See the Connection topic for additional information.
Schedule Frequency
This job group can be scheduled to run as desired.
Run Order
The 0.Collection Jobs must be run first and in order. The other Redshift sub-job groups can be run in any order, together or individually, after running the 0.Collection Job Group.
Run the solution at the top level.