SQL Sever Agent Jobs
Jobs are used to schedule background tasks (https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job?view=sql-server-ver15).
SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks. It runs as a Windows service so it can start automatically when the system boots or it can be started manually. (https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-ver15).
Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log shipping sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some T-SQL or command line statement are also common. SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.
There are many good articles about this topic:
https://blog.sqlauthority.com/2018/11/29/sql-server-sql-server-agent-missing-in-sql-server-management-studio-ssms
https://www.sqlshack.com/faq-and-examples-about-the-sql-server-agent
https://www.mssqltips.com/sqlservertip/4848/getting-started-with-sql-server-agent--part-1/
Example:
Answer:
