Overview
SQL Server Agent is an important component of SQL Server that allows you to schedule and automate database and server administration tasks. You can configure a process and then have it run on a set schedule, either every day or during off-hours. Depending on the permissions granted to your account, you may be able to see all jobs as well as create your own jobs.
In addition to running the jobs on a set schedule, you can also run the jobs on demand.
Explanation
The SQL Server Agent node can be located in the root node when using Object Explorer. If you expand this node, you will also see other related items to SQL Server Agent.
Additinal Information
- Getting Started with SQL Server Agent – Part 1
- How to start SQL Server Agent when Agent XPs show disabled
- Running SQL Server Agent with a least privilege service account
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
