Tuesday 7 March 2023

SQL Server Tips: Job Scheduling In SQL Server That Runs Automatically At Your Scheduled Time

Leave a Comment

Hello everyone, toady in this article I will explain to you about making job scheduling in SQL server, which means you can create any type of job in SQL server and then run it automatically at your scheduled time intervals as per your requirement; here I will make a job which will run after every hour and it will export the SQL server table data to the MS Excel file. So here I will use the SSIS package for exporting data to Excel which we made in our previous article (Here).

For creating the Job in SQL server follow the below steps. (Here I use SQL server 2008.)

Start the SQL server 2008, and for creating the JOB we need to start the SQL server Agent service in SQL server. So first we check if the SQL server Agent service is running on my machine or not.

For checking the SQL server Agent service we go to object explorer in SQL server management studio and check the color of SQL server. If agent is red then agent is currently stopped, so start it by right click on it, and also you can start it from service page as shown in the below image. Go to Command prompt and type “Services.msc“ and hit Enter, it will open the Service window, now find the SQL server Agent service and start it.

Now Expand the SQL server Agent from the object explorer in SQL Server as shown in the below image and right click on “Jobs” and click on “New Job…” .

 A New Job window is opened in “General” Option; give any proper valid name to your Job. And also you can write description about your job.

Now go to next Tab “Steps;” in this tab you have to specify what you want to execute when this job is run, so click on new button , and it will open new window; name it “New Job Steps“.


Now give the proper name to Steps in “Step Name“ field. And then got to option Type in which you have which type of job you want, here in the dropdown list there are many options available.
     Active X Script
    Operating System
    Replication Distributor
    Replication Merge
    Replication Queue Reader
    Replication Snapshot
    Replication Transaction Log Reader
    SQL Sever Analysis Services Command
    SQL Sever Analysis Services Query
    SQL Sever Analysis Services Package

Here you can select any of then as per your requirement. Here I selected 11th (SQL Server Analysis Services Package) option and continued my work.

Now in the next option select the Package source file Type, so here you have multiple options, if you have package tin in your local file system the you can select it and if your package is stored in SQL server then select this option, here I will continue by selecting the “SQL Server”

Now in next option “Server:” select your server name on which your package is stored.

Than select your authentication mode either windows or SQL server authentication.

In next option (Package) browse your packages and select them. And then finally close this window by clicking on “Ok” button.

Here you can add multiple steps also and also arrange its execution sequence one by one. Finally click on Ok button and close the window.

Now in new tab “Schedules”. You can schedule the time on which you have to run this job. So click on new button it will open new window (New Schedule window).
In “New Schedule window” we set schedule for job to run every hour so select parameter as shown below.

Name: Schedule 1
Schedule Type: Recurring
Enable: Mark

In frequency Tab

Occurs: Daily
Recurs Every: 1 day

Daily Frequency

Occurs every: 1 hour

Now click on OK button and close this schedule window. Here you can also add multiple schedules for job.
Now next in Tab “Alert” you can set the alert message when job executes  successfully or generates errors then it will display some alert message to user.

 Now move to next tab “Notifications;” you can send the notification, which means when your job is executed the job status is sent to user either it successfully executes or any error occurs. You can get alert by email or also generate log file.

 Now move to next tab “Targets;” here you have to select the server on which your job is executed. Now close this window by clicking on OK button.

Your job is ready to use, as show in the below image you can see “Job1”. 

Thank for reading my article if you have any query regarding this article then you can ask in the comment section.

Best SQL 2019 Hosting Recommendation

One of the most important things when choosing a good SQL 2019 hosting is the feature and reliability. HostForLIFE is the leading provider of Windows hosting and affordable SQL 2019, their servers are optimized for PHP web applications. The performance and the uptime of the hosting service are excellent and the features of the web hosting plan are even greater than what many hosting providers ask you to pay for. 

At HostForLIFEASP.NET, customers can also experience fast SQL 2019 hosting. The company invested a lot of money to ensure the best and fastest performance of the datacenters, servers, network and other facilities. Its datacenters are equipped with the top equipments like cooling system, fire detection, high speed Internet connection, and so on. That is why HostForLIFEASP.NET guarantees 99.9% uptime for SQL 2019. And the engineers do regular maintenance and monitoring works to assure its Orchard hosting are security and always up.


Post a Comment