Is it possible to trigger a replication job from witin a DTS Package?
I want to do the following
execute SP1
on complation
execute replication job 1
on completion execute sp2
on complation execute replication job 1
oncomplation execute sp1

The replication job is already set up and scheduled. The reason I want to
do this is because the different steps are dependent on each other and you
have to be very carefull id you schedule them as you're not always sure how
long they will execute, and they're all dependent on the complation of the
previous job

look up sp_start_job in BOL. You could use this in an ExecuteSQL task

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Nico" <Nico (AT) discussions (DOT) microsoft.com> wrote

Thanx for the quick reply.....I got that one working....have another problem
though.....

I cannot execute a remote sp from an agent job. I get the folloing error.
Job 'nicotestjob' : Step 1, 'execute nicotest' : Began Executing 2004-10-13
10:33:13
Msg 7410, Sev 16: Remote access not allowed for Windows NT user activated by
SETUSER. [SQLSTATE 42000]

Any advice ?

"Allan Mitchell" wrote:

Shall I tell you what I do?

I have a table on the destination server that has a trigger. I insert the
name of the job I want to start on the remote server and the trigger
concatenates this to the sp_start_job and fires the orrect job.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Nico" <Nico (AT) discussions (DOT) microsoft.com> wrote

Hi Nico
I am not trying to provide an answer. I am trying to set up something
similar to what you have done. How do you check the completion of SP1 or a
replication job when they are part of a DTS package? Does
'completion(success\failure) of a step' really mean the acutal success or
failure of the process within that step? or does it mean the status of the
execution step?



"Nico" wrote: