search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
358 stars 224 forks source link

SqlAgentOperator: Configure operator on duty schedule #1383

Open cosmos500 opened 5 years ago

cosmos500 commented 5 years ago

Details of the scenario you tried and the problem that is occurring

i have successfully created and operator with dsc but how do you add a schedule for the operator?

Verbose logs showing the problem

N/A

Suggested solution to the issue

The DSC configuration that is used to reproduce the issue (as detailed as possible)

# insert configuration here

SQL Server edition and version the target node is running

SQL 2016

SQL Server PowerShell modules present on the target node

The operating system the target node is running

Windows 2016

Version and build of PowerShell the target node is running

5.1

Version of the DSC module that was used ('dev' if using current dev branch)

12

johlju commented 5 years ago

Do you mean that you want to schedule an agent job? 🤔

cosmos500 commented 5 years ago

When you create a new operator you can add there on duty schedule

johlju commented 5 years ago

Ah, I see. That is not yet supported. How would you suggest this functionality is added? Should it be one or more properties added to the resource SqlAgentOperator, or does it need to be a new resource?

cosmos500 commented 5 years ago

well i am fairly new to all this but the same module would work

johlju commented 5 years ago

It's alright, let's label this as an enhancement and help wanted so that someone else in the community can help figuring out the best way to add this functionality. 🙂