SQL job to move backup file

SQL Server Administration
1

Hello,

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?

2

Why wont they allow bat files, how about powershell? Other option is ssis package in a SQL jobs

3

Don't know, I'm new there and still getting used to all of ITs little "nuances" (they're trying to outlaw ODBC connections into the main production database even though they use a dedicated account whose permissions are limited to a couple of views, for example!)

4

Use powershell commands in SQL Server agent - it has a powershell subsystem available.