creating and scheduling a job in sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » creating and scheduling a job in sql server...

creating and scheduling a job in sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

solus

Posted Thursday, August 06, 2009 9:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244

I have to periodically delete data from a table thats over a certain age. I can create a stored procedure that would do this, but how do I create a job and schedule it so that it executes the stored procedure at a predetermined time each day ?

Post #766333

Adam Angelini

Posted Thursday, August 06, 2009 10:07 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:29 PM
Points: 1,084, Visits: 806

it's easy to implement. look in books online (help) under the topic "jobs [SQL Server Agent]"

Post #766363

« Prev Topic | Next Topic »

Permissions