Explanation To schedule backups using a SQL Server Agent job To automate and schedule a backup with SQL Server Agent: * In the Object Explorer panel, under the SQL Server Agent node, right click Jobs and select New job from the context menu * In the New Job dialog enter a job's name * 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. * Click ok to add a step, and click OK to create a job * To schedule a job, in the New Job dialog, under the Schedule tab click New. * In the Job Schedule select an occurring frequency, duration and a start date and click OK: * 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