Viewing 3 posts - 46 through 48 (of 48 total)
here is one way:
each replication agent will have one job to start it, if the job stops or fails to start for whatever reason, you can query through msdb..sysjobs union...
February 8, 2006 at 10:36 pm
#619673
Use sp_dropsubscription so you don't have to browse EM, below is the minimum permission needed to execute the command.
from BOL:
Only members of the sysadmin fixed server role or db_owner fixed...
February 8, 2006 at 10:17 pm
#619671
hi i tried, this.
i'm trying to start the winvnc.exe installed on one server in a sql job packaged inside another vb exe file. The job started the exe file but...
November 18, 2004 at 12:04 am
#530581