I agree with you but right now our structure is more a do it yourselves and you need to make sure that you don't mess up with the data we hold.
I will let you know if I succeed in making this work through SQL Agent. I found another way around this by setting up a schedule tasks with a batch file.