you have many steps that are dependant upon the previous step being completed. therefore you have to signal somehow that the previous step is completed. just because the ftp process is started it doesn't mean that you can go to step 2 immediately. i.e. start/wait ftp job2: if not exist file.sql goto job2 start/wait sqljob in otherwords you must wait until the database is created and no matter how fast you might be in doing it manually the computer is always faster so you have to add a delay between step 1 and step 2 or have step 2 test to make sure that its dependancies have been satisfied before it executes.

you have many steps that are dependant upon the previous step being completed. therefore you have to signal somehow that the previous step is completed. just because the ftp process is started it doesn't mean that you can go to step 2 immediately. i.e. start/wait ftp job2: if not exist file.sql goto job2 start/wait sqljob in otherwords you must wait until the database is created and no matter how fast you might be in doing it manually the computer is always faster so you have to add a delay between step 1 and step 2 or have step 2 test to make sure that its dependancies have been satisfied before it executes.