Run Powershell script within Maintenance plan

Question

I have a SQL 2008 database, run on 64 bit Win2008 Server. I created a pretty simple powershell script that automates a bunch of tasks. I would like this script to run as part of our maintenance plan. Anyone have any tips, or another suggested way to schedule it to run?

It needs to run as admin - I know this is not ideal, but am hoping I can have it execute as admin. I currently open Powershell as admin, and execute the script manually every morning.

In case it matters, the script: zips the backup file (7z) and moves it to our backup location juggles some files - keeping the latest backup in a particular network location, and moving what was the most recent backup into the #2 spot deletes the bak files

I am new to powershell and am pretty pleased with the time savings so far from the script, but want it to run without counting on me to run it.

Answer 1

You can run your PowerShell script within SQL Server 2008 Agent (SQL Server's job scheduler). Using SQL Server Management Studio, create a SQL Server job and select a PowerShell job step. In the job step information specify the full path to your PowerShell script file.

Answer 2

Try this: http://www.searchmarked.com/windows/how-to-schedule-a-windows-powershell-script.php

In short, save the PowerShell script as a .ps1 file, make sure PowerShell will execute PowerShell scripts, create a bat file that calls powershell and feeds it your script and then schedule the .bat file.

And here's a juicy Google search for good measure: http://www.google.com/search?q=schedule+powershell+script