An SQL Server-scheduled job can run database commands or it can run Microsoft Windows commands in standard executable program files or in the PowerShell scripting language.

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.

In SQL Server 2008 and newer, when you create a new job step and click on the Type drop down, you see what's in Fig. 1. Figure 1. Creating a new job step. (Click image to view larger version.) ...

It is possible to use the SQL Server Agent to execute PowerShell scripts. If you've worked with the SQL Server Agent to run jobs on your server, you already know that whenever you define a job ...