Configure the TimeXtender Scheduler Service

During the installation of TimeXtender, a service is installed on the local machine call "Discovery Hub Scheduler. This service initiates scheduled execution packages that handle the recurring updates of database tables and semantic models in Discovery Hub.

Create the Service Account used to run the Scheduler Service

This service will run during the specified schedule to update the tables and semantic models, similar to how a user might execute stored procedures in SQL Server. In this way, the user account configured to run the service will require sufficient user rights within the SQL server to read and write to these tables. So the service must be configured to "Log On As" a user account with the sufficient user rights.  We recommend using a Service Account for this purpose which should be created when you Configure User Accounts & Permissions.

Assign the Service Account to a Project Repository

To successfully run execution packages, the Service Account must access the metadata stored in the Discovery Hub project repository. The steps below explain how to link the service account with the correct project repository database.

  1. Log into windows using the service account that will be used to run the scheduler service and launch Discovery Hub. Alternatively, you can navigate to the timextender.exe application file in the Discovery Hub installation directory and press Shift+Right-Click and choose Run as different user.


  2. Enter the credentials for the Service Account and click OK. This will run the Discovery Hub application as the Service Account user.


  3. Discovery Hub will ask you to enter the SQL Server and Database name for the project repository. Enter the server and database for the repository you want to associate with the scheduler service. Click OK/Next to confirm your settings. 


  4. Close the instance of Discovery Hub running as the Service Account.


Configure the Service

  1. Open Discovery Hub from the start menu.
  2. In the Tools menu of Discovery Hub, click on Windows service Setup.


  3. If upgrading from a previous version of Discovery Hub, Stop & Disable previous versions of the service.
    1. Click Options > Filters > All Versions
    2. Find the previous version of the service that's running, Right click > Stop Service. Then, Right-click > Start Mode > Manual. This will stop and disable the previous version of the service.
  4. Find the current version of the Discovery Hub Scheduler service in the list. Right-Click > Start Mode > Automatic Delayed


  5. Right-Click the scheduler service > Change User Name and Password. Enter the credentials for the service account. Click Update and you should receive a confirmation if the credentials were accepted. 


  6. Right-Click the scheduler service > Start Service.


  7. If the configuration was done correctly, the service should start and show "Running"

Configure Auto-restart of the Service (Optional)

  1. Open the Services dialog in Windows. 


  2. Right-click the Discovery Hub Server Scheduler service and select "Properties".
  3. On the Recovery tab, the First failure and subsequent failures should be set to "Restart the service".


Scheduler Service Troubleshooting

  1. If you receive a message that the service started and then stopped the most common reasons are listed below:
    1. The Service Account has not been properly assigned to the project repository. Please go back to this section and follow the steps. 
    2. The Service Account does not have the necessary permissions in SQL Server. Please review the article Configure User Accounts & Permissions and ensure the Service Account is either SysAdmin or dbOwner on the Project Repository database. Alternatively, you can use SQL authentication when connecting to the repository from Discovery Hub, as long as that SQL user has the permissions mentioned above. 
  2. If you have started the service, but scheduled executions result in errors regarding the wrong repository, It could be that the old version of the service is still running. 
    1. Find the previous version of the service that's running
      1. Right click > Stop Service.
      2. Right-click > Start Mode > Manual. This will disable the previous version of the service.
Was this article helpful?
0 out of 0 found this helpful


  • 0
    René Imthorn

    How to remove the old services?

  • 0
    Joseph Treadwell

    Hi @Rene,

    When you uninstall a previous version it will also remove the services of the same version. 

  • 1
    René Imthorn

    Hi Joseph,

    I did, but they were still there.

    I managed with the cmd: "sc delete <service name>" 

  • 0
    Joseph Treadwell

    That is strange, typically this removes all related services as well. Glad to know there is a workaround. Thanks for sharing!

Please sign in to leave a comment.