6.5 Adding Repositories to the Task Scheduler Service

For QDBs and the CCDB to function correctly, you must use the Task Scheduler Configuration Utility to add them to the Task Scheduler service so that it can schedule required SQL Server jobs.

To add a repository to the service:

  1. In the Tasks pane, click Add.

  2. Provide the required information about the repository.

    If you are using a port other than the default port (1433) for communications with SQL Server, you must use the format SQL_Server_Name/Instance,Port_Number when you specify the SQL Server name.

  3. Click OK.

After you add the repository, the Task Scheduler service creates and runs the SQL Server jobs that are associated with the repository. If the SQL Server that hosts the repository is not available for any reason (for example, the Task Scheduler service starts before the SQL Server service), the Task Scheduler service is not able to add the SQL Server jobs and AppManager generates a repository synchronization error in the Control Center console. Because the Task Scheduler service checks all of the SQL Servers that you add to the Task Scheduler Configuration Utility every 30 minutes to discover new or removed SQL Server jobs and update the Configuration Utility, AppManager should automatically resolve the error within 30 minutes. If you need to resolve the error more quickly, you can modify the SQLJobDiscoveryInterval parameter in the NetIQTaskScheduler.exe.config file (located by default in C:\Program Files\NetIQ\AppManager\TaskScheduler\bin). For more information about the configuration file, see Configuring the Task Scheduler Service and SQL Server Jobs in the Administrator Guide for AppManager, available on the AppManager Documentation page.

To remove a repository from the service:

  1. In the Tasks pane, click Remove.

  2. Select the repository you want to remove, and then click OK.

You can also use the utility to perform the following tasks:

  • Change the authentication method for a repository

  • Disable a SQL Server job

  • Change the schedule for a SQL Server job

For information about performing these tasks, see the Administrator Guide for AppManager, available on the AppManager Documentation page.