Dynamic SQL server job (two jobs at the same time)

[Corran007]

In our stores we have a sqlserver database server. i have it set so it starts with integrity which calls optimization which calls the sql server backup. Now i need to do a couple things, at basically the same time. i need to start the bakup to tape command. i also need to start the copy the file accross our instore network to online storage. I would like to do these both at the same time.

What would be the best way to accomplish this? the backups finish at differnt times since thier size varys widly. My initial thought would be to have the creation job create a sqlserver job on the fly to start in say a couple mins that would do the copy then delete itself wehen finished. Then the next step in the creation job would start the tape backup. That way i can have both running together.

im intersted if anyone else has thoughts on this. Has anyone had this problem and if so what was your solution for it? i have no problem changing my current solution. On a related note. has anyone created a sqlserver job on the fly like this? thanks for your time

 

[dbomrrsm]

I would do this with DTS - forum961

[blue]DBomrrsm[/blue]

 

[Corran007]

Oh, i should add i really dont want to use DTS as an option due to having to change 50 dts packages if i change it. I wrote an applicaiton that i use to update the systems all at the same time with sql. and since ive never figured out how to send over a dts package via straight sql from one server to the other, its not currently an option. of course if someone knows how to do that, that would work as well.