Hope someone can help.
I'm in a new job and am currently manually having to do the following:
(a) go into \vp-doca\backups\archive\ and delete any backups older than three days (*.bak files)
(b) go into \vp-doca\backups\ and move the latest backup into \vp-doca\backups\archive\
Easy-peasy using a batch file but the IT dept won't allow them to be scheduled; they're happy with SQL Agent jobs though (which is handier because the job can fire off an email stating whether the job has succeeded or failed).
Anyone know how I start?