Question

Describe How You Would Use SQL Agent.

Answer 1

SQL agents enable you to perform commands at a specific time repeatedly. For example, backups are done frequently at particular times. I use SQL agents to perform backups daily at a time when no one is using the system. I do my backups at 3:00 am using SQL agents.