Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 527

A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.

3 votes
1 answer
30k views

How to run SQL Job only on primary replica in AlwaysOn Availability Groups? [duplicate]

I have SQL Jobs that need to only on primary replica on AlwaysOn Availability Group. … When jobs were originally created ServerA was primary, at later point ServerB became primary so jobs that were on ServerA failed and jobs had to be manually recreated on ServerB to run properly. …
8 votes

How to run SQL Job only on primary replica in AlwaysOn Availability Groups?

There are scripts and tools that can be used to copy jobs from primary replica to the secondary replicas. …
Vladimir Oselsky's user avatar