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.