How to create JobSchedular in sqlserver2008 R1?

Question

Hi How to create Job Schedular in sqlserver2008 R2? * I need get automatic daily backup and weekly backup in Sqlserver2008 R2. * I have created stored procure in that source path and desitnation path details. * How to call stored procedure in Job Schedular. I have no idea plz explain me step by step process. Thanks in advance

Pradip Pandey · Answer

Please refer this article http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/ Hope it will help you.

Hanook · Answer

https://www.serverintellect.com/support/sqlserver/scheduled-db-backup-plan/

Hanook · Answer

Refer http://blogs.msdn.com/b/sqlagent/archive/2010/10/12/create-a-database-backup-job-using-sql-server-management-studio.aspx In the same way go to Schedules Pane in the JOb Creation dialog box.. There you can schedule daily run at specific time...