How to schedule a MSSQL Server Job
Download SQL Server Management Studio from the link below:
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server…docs.microsoft.com
It is compatible to the following OS: Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2016, Windows Server 2012 (64-bit), Windows Server 2012 R2 (64-bit), Windows Server 2008 R2 (64-bit). As you can see this software is only for Windows users there are other software you can use like SQLPro to remote to SQL Server from Mac.
You can access your current SQL Server by installing this free software and connect to your from multiple computers based on your authentication.
Add a new Job
SQL Server jobs becomes very useful when we have a series of steps that we want to run after each other or we want to schedule them to run in a frequent basis. SQL Server Jobs are easy to setup and maintain. In the following step, I will explain how to create a new job.
- Connect to the server from SQL Server
2. After you are connected, from the left bar, find and expand SQL Server Agent/ Jobs: You can find list of all the scheduled jobs.
3. Right click on Jobs and select New Job …
4. A new window will be open that you can fill the name and category of the job, there is also a description.
Job categories are helpful for organizing your jobs so you can easily filter and group them. For example, categorizing all your database backup jobs in the Database Maintenance category is easy to audit your jobs in view the backup history. You can also create your own job categories.
I recommend always add a description of the job running for yourself in the future and other who are looking at this job.
5. From the right menu, select Steps. In a job you can add multiple steps and they will run right after each other.
6. When you click on a New button, another window will open that you can type your Step name, Step Type and Command. Select a database, and select T-SQL as type. Enter your SQL command in the text area and press OK.
You can read more about different step types here.
You can add as many steps as you like to a single job and sort them, or you can set a job to start from a specific step, therefore it will skip prior steps if there is any.
Schedule a SQL Server Job
From the left bar of the job, click on Schedules.
Edit and New Windows are very similar so you can edit a schedule the same way as you are creating a new one.
Add a name for the schedule, make sure the enable checkbox is checked and pick a type from the drop down and select schedule start date and occurrence frequency. Then, press Ok.
Voila! You have created and scheduled a SQL Job in MSSQL Server.