Loading

How to create JobSchedular in sqlserver2008 R1?

s kumar

12y1.9k

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradip Pandey12y ago
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.
0
Hanook12y ago
https://www.serverintellect.com/support/sqlserver/scheduled-db-backup-plan/
0
Hanook12y ago
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...
0