I guess the problem is because the steps are being executed with no synchronization. Subscription and Publications are being deleted prior to agents finish their jobs.

Is waiting...

When ever we get new data we update dev server and then synch the target server. I first used publication / subscription steps using EM and it worked fine...

Thank you Warren for a quick reply. I have updated a table on source server prior to creating publication/subscription and running a snapshot agent. However, after everything has...

Sorry for not making my question clear. My question is that when I start snapshot agent, it also seems to run the distribution agent. But somehow the distribution...

Thanks Jay for the tips. You are right that the generated sql (for creating publication) has the snapshot agent name. I used this name to start the job....

Actually I tried what I described earlier. I was able to run both snapshot and distribution agents after I found their names.

However, after I delete and recreate...

Thank you gentlemen for your tips.

Lets consider this scenario:

- I create publication using EM and then generate SQL scripts and store it in a SP.

- I create a SP with...