Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

How to prevent jobs from failing on one SQL cluster node?

  1. Last updated
  2. Save as PDF

Some Changepoint SQL jobs are failing on one cluster node, as the specified path was not found on the failover server. On the other cluster node where jobs work fine, there is a folder structure and some dll files from Changepoint. How can we ensure that the same jobs would work on both cluster nodes?

Scheduled jobs need to be installed on both cluster nodes. Related folders and files can be copied from one SQL node to the other.
E.g. if the SQL server is looking for the files under C:\Program Files\Changepoint\ScheduledJobs then the folder structure should be copied from node 1 to node 2, so that the path in the SQL job step points to the same folder where the files reside.