Qus:    Do you know anything about the sql server agent and what is the use of sql server agent?
Dec 05, 2020 14:23 2 Answers Views: 744 FRAUSKY

 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.

Prev Next
Answers (2)
PARTH Dec 07, 2020 07:38
Answer:   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.

RAMU Dec 07, 2020 08:04
Answer:   It will help to performance the administration activities like job scheduler, which run on daily actives for pulling the records

Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect