Post reply

creating and scheduling a job in sql server 2005

  • August 6, 2009 at 9:40 am

    #212942

    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 ?

  • August 6, 2009 at 10:07 am

    #1035504

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply