Skip to main content
Planview Customer Success Center

How to set up the scheduled jobs in a SQL Always-on Availability Group

In a SQL always-on group, the database scheduled jobs must be run on the primary server only because the secondary server is in read-only mode.

However, if you plan to install the scheduled jobs on the secondary server, for example, to prepare for a fail-over scenario, you must do one of the following:

  • stop the SQL Server Agent to prevent any job from being executed
  • manually disable all scheduled jobs
  • modify each job by adding an additional first step that terminates the job if it is not executed on the primary server