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
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
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
Viewing 3 posts - 46 through 48 (of 48 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy