SQL Server Job Component

SQL Server Services SQL Server The SQL Server Agent is a basic, automated system and service package. These functions can be used for various tasks such as executing T-SQL commands, deploying SSIS packages, or maintaining databases. 

Some of the major features of a SQL Server job are as given below,

General

Definition- The task itself consists of one or more product steps. It represents the entire project or series of tasks to be performed.

Attributes

• Name- The descriptive name of the program.
• Description- An optional description of what the task is.
• Category- Helps organize task groups (e.g., Database Maintenance, Backup, etc.).
• Enabled/Disabled- Displays whether the function is enabled or disabled.

Job Steps

Definition- These are the individual actions or tasks that work together. Each step can follow a specific command or procedure.
 

Attributes

• Step Name- Descriptive name of the step.
• Step Type- Specifies the type of action the step performs, such as a Transact-SQL script, SQL Server Integration Services (SSIS) package, or operating system command.
• Command- The actual command or script that performs the step.
• On Success Action- It describes what will happen if the step is successfully completed (e.g., move on to the next step, quit the task, etc.).
• On Failure Action- Specifies what will happen if the step fails (e.g., retry, quit, etc.).

Schedule

Definitions- Schedules specify when and how often a task is to be performed. They control the running time and frequency.
 

Attributes

• Name - A descriptive name for the system.
• Frequency- The number of times the task should be performed (e.g. daily, weekly, monthly).
• Daily Frequency- Specific times or intervals in a day that a task should run.
• Start Time/End Time- Defines the window that can be used.
• Days of the Week/Month- Specifies the days on which the job should be active.

Alerts

Definition- Alerts can be configured to monitor job performance and report certain events such as job failure or job abortion.
 

Attributes

• Alert Name- The descriptive name of the alert.
• Alert Type- Identifies the conditions that trigger the alert (e.g., failure, success, or specific error conditions).
• Notification- Specifies how to send notifications (e.g. email, net send).

Notifications

Definition- Notification specifies how alerts are sent and to whom alerts are sent when events (e.g., job failures) occur.
 

Attributes

• Email- Sends notifications to specified email addresses.
• Pager- Sends pager notifications.
• Net Send- Sends notifications via network messages.
• Write to the Windows Application Log- Writes information to the Windows Event Log.

Target

Definition- The last tab is the “Target” tab which shows you options for target servers; you can even select multiple target servers.

Also, Read: What is SQL server job, and why is it used?