Another newbie question

What is the role of the SQL agent and what is the difference whether it will
run automatically or manually (I am trying to run the replication wizard)
Thanks,
Shmuel
There are several agents associated with replication and they are
essentially jobs fundamental to replication. Have a look in BOL for
replication,agents for a description of each agent. Running continuously
will help you work with miniumum latency, but you will not then have control
over when the load is placed on your server, and connectivity is mandatory.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||i'm kinda new at this too... but it seems to me that automatic means the same thing as scheduled... you can have it run once a day at a certain time, etc... manual means you want to control if and when it runs.
Andrea Garcia
Yahoo IM: mmmmojobootay
CS degree arriving in: July 2005
www.millionformarriage.com
"S Shulman" <smshulman@.hotmail.com> wrote in message news:uQ8Z4J0IFHA.2648@.TK2MSFTNGP14.phx.gbl...
What is the role of the SQL agent and what is the difference whether it will
run automatically or manually (I am trying to run the replication wizard)
Thanks,
Shmuel
|||sql server agent is the component of sql server which runs all of your
jobs. If you configure it to run automatically it will start whenever
you reboot your machine. If you configure it to run manually you will
have to manually start it.
S Shulman wrote:
> What is the role of the SQL agent and what is the difference whether it will
> run automatically or manually (I am trying to run the replication wizard)
> Thanks,
> Shmuel
>