SQL server agent has a major role to play in the day to day task management of the SQL server database administration. Its ultimate purpose is to effectively implement the task proteins easily aligned to the scheduler engine which allows them to run for a specific time and date. It also offers two modes of authentication defined in SQL server, these modes are-

  • Windows mode
  • Mixed mode

If there is a need to change the mode then it can be done from the tool menu of the SQL server configuration properties in the security page section.

BY Best Interview Question ON 17 Oct 2019