In the previous chapter, you understood how to filter and retrieve information about a SQL Server Agent. The responsibility of DBAs for SQL Server Agent is also the creation and alteration of those SQL Server Agent objects. This chapter will provide you with all of the tools to do this easily.
Now that you are learning how useful and powerful dbatools is, you will also want to know how to schedule the running of dbatools scripts with SQL Server Agent Jobs, and we will show you the most stable and robust method that we use to do this.
In the last chapter, you used Find-DbaCommand to find all of the dbatools commands that interact with the agent. Let’s search for all of the Commands that you can use to create or alter Agent objects. The PowerShell command Get-Command returns commands you can filter by a module such as dbatools with -Module switch, verb with the -Verb switch and by noun with the -Noun switch. As you can see in Listing 19.1, the verbs that we use to create, alter and remove are New, Set and Remove.