dsccommunity / dsccommunity/SqlServerDsc
SqlAGSyncJob: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Consider creating a resource to synchronise Agent jobs between nodes of an AG
Looks at all nodes in a specified AG
Looks at all DBs in a specified AG
Looks for any jobs dependant on a DB in the Primary node of the specified AG
Copies job from primary AG node to all secondaries
xSQLServerAOGroupJobStatus can be used to ensure job's are in a specified state (enabled vs disabled) for primary or secondary nodes
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing xSQLServerAOGroupJobStatus and the proposal's behavior: inspect AG nodes and databases, identify jobs dependent on a primary-node database, and synchronize them to secondaries. Done means the new resource has defined behavior for primary and secondary job states and covers the specified AG synchronization flow; no implementation file or test is named.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100