Since he did not provide the actual code that he was having trouble with, or the error he was getting, it is a little hard to provide help.

"Damn it Jim,...

You can start the job on the other server using the OSQL command within an Operating System command (CmdExec) job step or using XP_CMDSHELL.

Well, somtimes you just need a cursor.

There are no dumb tools, just dumb workmen. 

Try this:

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

You can also backup to multiple files using the regular SQL Server backup command, but if you need to compress them, you will have to use a file compression utility...

If you want a date table, you can use my own personal favorite.

Date Table Function F_TABLE_DATE:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Good stuff Ryan!

Did you compare the runtime against any of the other code posted on this thread?