SQL Server Agent Jobs are a powerful tool for automating repetitive tasks in SQL Server. Whether you are using a Linux-based or Windows-based SQL Server, you can easily create and run SQL Server Agent Jobs using SQL Server Management Studio (SSMS).
Prerequisites
Before you begin, make sure you have SQL Server vNext installed on your Linux-based SQL Server. Additionally, ensure that SQL Server Agent is installed on your server to create and run jobs.
Step 1: Connect to your SQL Server
First, open SSMS on your Windows client and connect to your Linux-based SQL Server. Enter the Linux server name/IP and choose SQL Server authentication to enter the sa login and password. Click on the connect button to establish a database connection from the Windows client.
Step 2: Create a new job
Once connected, expand the SQL Server Agent folder in SSMS. Right-click on the “Jobs” folder and choose “New Job…” to start creating a new job.
Step 3: Provide job details
In the General tab of the job creation interface, enter the name and description for the job.
Step 4: Add a job step
In the Steps tab, click on the “New” button to add a new step to the job. Specify the type of step (e.g., Transact-SQL script) and enter the T-SQL code that will be executed. Press the “OK” button to proceed.
Step 5: Schedule the job
In the Schedules tab, click on the “New” button to create a new schedule for the job. Specify the details for the schedule, such as the frequency and time of execution. Press the “OK” button to proceed.
Step 6: Run the job
Once the job is created, you can check the job history to verify that it has not run before. Right-click on the job name and select the “View History” option. To run the job, right-click on the job and click “Start Job at Step”. If the job executes successfully, a success message will be displayed.
Step 7: Validate the job success
To validate the success of the job, check the job history as shown in the interface. You can also verify the execution by checking the backup file location on the Linux server.
SQL Server Agent Jobs provide a convenient way to automate tasks in SQL Server, regardless of the operating system. By following these steps in SQL Server Management Studio, you can easily create and run jobs to streamline your database management processes.