What is SQL Agent?
SQL Agent, also known as SQL Server Agent, is a relational database management system (RDBMS) of Microsoft SQL Server. SQL Agent enables the database administrator (DBA) to perform automated execution jobs, as well as other administrative or value-added database tasks such as: B. Schedule backups.
SQL Agent is an integral part of Microsoft SQL Server. It runs only as a Windows service and allows you to handle a wide variety of tasks, such as: B. Backup automation, database replication setup, job scheduling, user permissions and database monitoring.
These tasks do not necessarily have to be SQL Server related. For example, a daily backup job can be created to invoke an external program (e.g. WinZip) with a database backup to compress the result of the backup file and then move the file by invoking the MOVE command.
SQL Agent jobs consist of a series of steps that use a graphical user interface (GUI) wizard that enables DBAs of any skill level to set up jobs that consist of a complex set of tasks. After a job is set up, the DBA can schedule a frequency of execution; for example, it could be one-time, daily, weekly, or monthly.