Interview Question
Qus: Do you know anything about the sql server agent and what is the use of sql server agent?
SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system (RDBMS) background tool. SQL agent allows the database administrator (DBA) to schedule automated execution jobs, as well other management or value-added database tasks such as backups.
The use of SQL Server Agent is to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.
SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.
Answers (2)
The use of SQL Server Agent is to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database.
SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.