Is there way to run something on subscriber after distribution agent pushed transactions?

I need execute stored procedure on subscriber right after distribution agent
finished pushing transactions.
How to do it?
I don't have anonymous and pull subscribers.
MS SQL2K+SP3a
In the best we trust
Georgy Nevsky
If you are not running continuously you can make this the 4th job step.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Georgy Nevsky" <apokriffree@.hotbox.ru> wrote in message
news:%23gVfg7UCFHA.2032@.tk2msftngp13.phx.gbl...
> I need execute stored procedure on subscriber right after distribution
agent
> finished pushing transactions.
> How to do it?
>
> I don't have anonymous and pull subscribers.
> MS SQL2K+SP3a
>
> --
> In the best we trust
> Georgy Nevsky
>
|||I'm manually running distribution agent to push changes from publisher to
subscriber and I'm running that on publisher but I need execute stored
procedure on subscriber so I can't add that as last step. Is there other
way?
In the best we trust
Georgy Nevsky
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O9n8fCWCFHA.3784@.TK2MSFTNGP15.phx.gbl...
> If you are not running continuously you can make this the 4th job step.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Georgy Nevsky" <apokriffree@.hotbox.ru> wrote in message
> news:%23gVfg7UCFHA.2032@.tk2msftngp13.phx.gbl...
> agent
>
|||In my push subscriptions, I have a trigger on the MSsubscription_agents
table and I check the status flag last_sync_status and call sp_start_job to
do some reporting following the push (I think 2 is successful).
Message posted via http://www.sqlmonster.com