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 step, ...

Understanding SQL Server Agent SQL Server Agent is a popular tool from Microsoft for scheduling programs to run on Microsoft's SQL Server database platform.

In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions.

Powershell can schedule it for you! Just script something against the SQL Server Agent to get automated now.