SQL Server Agent:-
• SQL Server Agent uses SQL Server to store job information
• A job is a specified series of actions that can run on a local server or on multiple remote servers
• Jobs can contain one or more other job steps
• SQL Server Agent can run on a job on a schedule
• To a response or a specific event or manually
• You can avoid repetitive tasks by automating those tasks
• SQL Server Agent can record the event and notify you via email or pager
• You can set up a job using the SQL Agent for SSIS packages or for Analysis Services
• More than one job can run on the same schedule, and more than one schedule can apply to the same job.