I think what you really want is to use SQL SERVER AGENT. It's a way to make jobs that are targeted at a database and have 'steps' which you can configure yourself. You then schedule the jobs to run as required (at a certain time each day for example or every x minutes / hours).
Ask your DBA they should be fine with this. At the very least they should be OK with taking your sql, looking at it very carefully and scheduing a agent job themselves if they don't trust you (which they probably wont if they are doing their job properly )
Charlie =============================================================== Msg 3903, Level 16, State 1, Line 1736 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION