SQL Server Schedule Jobs

Here, I will share some screenshots to show how to set up SQL Server Jobs using SQL server Management Studio.
SQL Server Schedule Jobs Step 1
Step 1: Create New Job.
SQL Server Schedule Jobs Step 2
Step 2: Provide Details for SQL Server Job.
SQL Server Schedule Jobs Step 3
Step 3: Click on Steps on left Panel and click on New to write Job Script.
SQL Server Schedule Jobs Step 4
Step 4: Select Database accordingly and write SQL scripts.
SQL Server Schedule Jobs Step 5
Step 5: Now, click on Schedules on left pane, give a Schedule Name and Type, set Schedule Frequency as per your requirement.

You can set up SQL Server Jobs following those easy steps. However, you can set Alerts or Notifications for Jobs.

Thanks
A Rahim Khan

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: