Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

SQL 2008 agents

I was looking for information on different types of agents in SQL 2008. Here are some examples:
log reader agent
queue reader agent
distribution agent
log reader agent
snapshot agent

Everything about those agents and other. Any tips?
0
itnifl
Asked:
itnifl
1 Solution
 
Brian ChanDBACommented:
Ummm....... Your list is basically related to database replication. When people are talking about SQL Server agent, it usually means a task that is done automatically by meant of a built feature which is like windows task scheduler job or cron jobs. That enables one to have regular task to be kicked at configured requirement, like time schedule, or even specific condition.

when you say "different types of agents", let correct that as "different types of jobs". because it is all run by the service call SQL server agent.

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now