What is Jobs in SQL Server. Explain? How to create a SQL Jobs in SQL Server.
What is Jobs in SQL Server. Explain? How to create Jobs in SQL Server?
Ask by Ravi Vishwakarma
Updated 18 Oct 2021
SQL Server 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.
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.
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..
8- Select General option in window explorer then provide a proper name in name option then click on OK.
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.
• Select File Path from SSIS Package.
• Then fill the path of where stored the locally stored the server
• Then Click OK.
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.
11- Select Notification Option, It will send you Email alert automatically when the Job will success or fails.
Here the successfully a SQL Job will create.