I have a script that runs in a Powershell script step of a SQL Agent job to do this.
Makes deployment pretty easy as it's just T-SQL to create the SQL Agent job
--------------------
Colt 45 - the original point and click interface 
I have a script that runs in a Powershell script step of a SQL Agent job to do this.
Makes deployment pretty easy as it's just T-SQL to create the SQL Agent job
--------------------
Colt 45 - the original point and click interface