|
Define SQL Server Agent.- SQL server agent is an important service of the server where instances of SQL server are running.
- The agent is responsible to run tasks that are scheduled to occur at specific times or intervals.
- The agent is also responsible to run replication task set by the administrators.
- It is a Microsoft Windows service which executes scheduled administrative tasks.
- It uses to store job information.
- It can run a job on schedule.
- It schedules jobs and handles other automated tasks.
- SQL Server Agent runs as a Windows service so it can start automatically when the system boots or can be started manually.
- It handles a variety of tasks such as backup automation, database replication setup, job scheduling, user permissions and database monitoring.
- SQL Server Agent allows the Database Administrator(DBA) to schedule automated execution jobs.
|
