Post reply

Automatic Updates in Sql Server 2005

  • September 29, 2008 at 5:02 am

    #193342

    How can I do automatic updates in sql server 2005? I have some records in a table that are more than 30 days old, everyday I would like sql server to delete all records that are more than 30 days old automatically.

    Is this possible in sql server? Or do I have to do this manually.

    Any help will be appreciated.

    Thanks a lot.

  • September 29, 2008 at 6:15 am

    #878343

    Create a scheduled job using SQL Server Agent.

  • September 29, 2008 at 6:22 am

    #878347

    Create a stored procedure that performs the required updates. Then schedule as an SQL Server Agent Job to run at scheduled intervals.

    http://technet.microsoft.com/en-us/library/ms190268(SQL.90).aspx

    .

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

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