Explanation/Reference:
Explanation:
To schedule backups using a SQL Server Agent job
To automate and schedule a backup with SQL Server Agent:
1. In the Object Explorer panel, under the SQL Server Agent node, right click Jobs and select New job
from the context menu
2. In the New Job dialog enter a job's name
3. Under the Steps tab click on the New button and create a backup step by inserting a T-SQL statement.
In this case the CHECKSUM clause has to be included in T-SQL code.
4. Click ok to add a step, and click OK to create a job
5. To schedule a job, in the New Job dialog, under the Schedule tab click New.
6. In the Job Schedule select an occurring frequency, duration and a start date and click OK:
7. To check a created job in the Object Explorer pane and under the SQL Server Agent ꢀ Jobs node right
click the job create above and select the Start job at step option
References:
https://sqlbackupandftp.com/blog/how-to-automate-sql-server-database-backups