1) Create a  demo database and insert sample data using the following script.

-- Create Demo Database

CREATE DATABASE DemoDB

GO

USE DemoDB

GO

-- Create a table 

CREATE TABLE TestData(id int)

GO

-- Insert sample data

INSERT INTO TestData(id) VALUES(1)

INSERT INTO TestData(id) VALUES(2)

GO

SELECT * from DemoDB.dbo.TestData

2) Create SQL Agent Job

Type in name of the SQL Agent Job as “Test Backup Job”

3) Create a backup job step

Select the page “Steps”

Click on”New” to create a new job step

Type in name for job step as “Backup Job Step” and T-SQL statement to backup database

-- Script to backup database

BACKUP DATABASE [DemoDB] 

TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\DemoDB.bak' 

Click Ok to add this step to the job

Click Ok to create this job

4) View newly created job under Jobs folder in Object Explorer; To Start this job right click on “Test Backup Job” (under SQL Server Agent –> Jobs node ) ; select “Start job at Step”

You will see a job start progress dialog

After Job completion, you would see the “Success” status set for this job

5) View Job History and logs – in Object Explorer, right click on “Test Backup Job”  (under SQL Server Agent –> Jobs node); select “View History”

You would see the recent job execution history and job step results  in log viewer

 

Creating Sheduled Job