--- title: "What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?" description: "What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?" author: "Ravi Vishwakarma" published: 2021-10-18 updated: 2021-10-18 canonical: https://www.mindstick.com/forum/156786/what-is-jobs-in-sql-server-explain-how-to-create-jobs-in-sql-server category: "mssql server" tags: ["sql server"] reading_time: 3 minutes --- # What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server? What is Jobs in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server). [Explain](https://www.mindstick.com/forum/157854/what-is-system-debugging-explain-some-system-debugging-tools-used-in-modern-computer-systems)? How to create a [SQL Jobs](https://www.mindstick.com/interview/33958/what-is-sql-jobs-in-database) in SQL Server. ## Replies ### Reply by Ashutosh Kumar Verma **[SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) Server [Jobs](https://yourviews.mindstick.com/audio/1057/six-best-self-employed-jobs):** A SQL Job is a specified series of action steps that are SQL Agents perform. SQL jobs is used to defines the administrative tasks that can be run one or more than one times and monitored for success or failure. A SQL job can run on one local server or multiple remote server. By using SQL job create automatically weekly backup, sending auto Emails, writing log files newsletter, and audit logs. To Create a SQL job you must have SQL Agent. To create a job you have must be the member of SQL server Agent fixed database role or be the sysadmin database fixed server role and also job can be edited by its admin or a member of sysadmin role. ## Create a SQL Jobs: There are several steps to create SQL jobs are as follow- 1- Open Object Explorer from your SQL Server Management Studio. Expand your **MSSQLSERVER.** 2- Expand **Databases** folder in your SQL Server. 3- In Databases folder expand **SQL Server Agent folder** and select **Jobs** folder and Right click on that folder. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/63e0324e-42c1-4f40-b2d0-097d74fd0dd8.png)\ 4- From option bar select ‘**new jobs**’ option. Then open a new Job dialog box window. 5- Write the name of your job in name option. Then click on **OK** button. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/c7d86f03-5d48-4a78-9ea0-d4e184e45c02.png)\ 6- Once you have complete the above process then you can see your create job in **SQL Agent** folder. 7- Right click in **SQL Agent** folder and refresh then the following option menu will appeared. then click on **Property** option.. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/483361f6-ec00-4f47-ab20-c521ffadcb85.png)\ 8- Select **General** option in window explorer then provide a proper name in name option then click on **OK**. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/aceb7083-8656-4698-a5b8-026989e49fcf.png)\ 9- After all selects the **Step** option from the menu list. • Enter the Steps **Name**. • Select **type** ‘ SQL Server Integration Service Packages’. • Select **Run** As Option as ‘ SQL server Agent service account. • SelectFile Path from **SSIS Package**. • Then fill the path of where stored the locally stored the server • Then Click **OK**. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/368522da-bdfa-4835-8dfe-c11412243b67.png)\ 10- Select **Schedule** Option then click New button then a menu list will execute. Here fill the schedule name. then select **timing** in which jobs will execute. From **Duration** option select ‘**no end date**’. Then click on **OK**. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/b71a616b-56fb-4e5b-bd0d-0022dafafcfe.png)\ 11- Select **Notification** Option, It will send you Email alert automatically when the Job will success or fails. ![What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?](https://www.mindstick.com/mindstickforums/82b2d189-2a41-4767-bf43-7c2fc061813b/images/a8a56dcd-f9f5-4d7a-954b-e67873687454.png)\ Here the successfully a SQL Job will create. \ --- Original Source: https://www.mindstick.com/forum/156786/what-is-jobs-in-sql-server-explain-how-to-create-jobs-in-sql-server Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.