Sql Job Scheduler - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Sql Job Scheduler

Author

Topic

kirangentlebreeze1987
Starting Member

14 Posts

Posted - 2010-04-16 : 10:09:07

Hello friends,i am new to this sql programming,i need to know about sql job scheduler.i need to delete all records in my table every 10 days.is it possible through sql job scheduler.if so,any body tell me how this can be done.

Thanks in advance

kkk

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-16 : 10:50:05

Create this procedure

create truncate_my_table
as
truncate table my_table

schedule this procedure to run every 10 days

Madhivanan

Failing to plan is Planning to fail

kirangentlebreeze1987
Starting Member

14 Posts

Posted - 2010-04-16 : 11:03:03

could you tell me how to schedule this stored procedure.how to use it with sql job scheduler?

kkk

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-16 : 11:12:23

Refer these
http://www.sqlservercentral.com/articles/Administration/sqlserverjobscheduling/2288/
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources