dsccommunity / dsccommunity/SqlServerDsc
SqlAGJobStatus: 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 set Agent jobs status 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 any DB in the specified AG
Sets job status to Enabled/Disabled for Primary/Secondaries as per passed in status parameter
This would be a child resource of xSQLServerAOGroupSyncJobs. It would be called after syncing jobs between all nodes of an AG
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 reading the existing xSQLServerAOGroupSyncJobs resource and its call flow, then map how AG nodes, databases, and dependent Agent jobs are identified. Done means a child resource can apply the requested Enabled/Disabled status for primary and secondary nodes across the specified AG, with behavior verified by the project's relevant tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100