Scheduler Job :

Some time we wanted to take backup our database weekly or daily or monthly once to maintain the log files and full data.
Below i pasted step wise scheduling job in SQL Server.
Step 1: First check whether your SQL Server Agent is Running

Step 2: Right click on SQL Server Agent > New>Job

Step 3: Give any name for the scheduler job and check Owner.

Step 4:  got to Step after General in left side of the window.

Step 5: Put Step name and select your Database that you want to take backup.

Step 6: paste this code according to your database name on the command box.

BACKUP DATABASE MSO

TO DISK = 'D:\Backup\MSO.BAK'

GO

Step 7: go to Scheduler option on left , put name and select schedule according to your requirement.

click ok and check next option in left side for your reference.