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