i am re-creating new publication through New Publication Wizard but it showing Error :- "sp_MSreplagentjobexists can only be executed in the 'distribution' database.Object 'PUM_NM' does not exist or is not a valid object for this operation."
Re-creating because i deleted Replication in following manner:-
- Delete the subscriptions
- Delete the publications
after this i run following commands:-
alter database distribution set offline;
drop database distribution;
Then i realize alter & drop distribution db is very wrong so i re-attached distribution db on both server through SSMS then run following commands to remove replications:-
exec sp_removedbreplication @dbname='distribution'
exec sp_removedbreplication @dbname="STBData" (STBData :- from which articles to be publish).
Now i am creating again Publication on "STBData" Server but it is displaying above error.
i also tried Disable Publishing but it is showing error "Invalid object name 'dbo.syssubscriptons'
Pls help me how i can re-create publications,subscriptions & replication.
i will be very thankful to you.