Post reply

Moving / editing / appending data

  • January 20, 2011 at 9:39 am

    #245710

    I need to on a schedule (some daily, some weekly) move, query, append and delete data from various tables in my database. I have the queries needed, but am not sure what process or procedure I should use to run these on an automatic schedule.

    Any advise would be appreciated.... even a source document to do some reading...

    I am running SQL 2005 Enterprise

    Thanks

  • January 20, 2011 at 11:17 am

    #1276140

    Use SQL Server Agent to make jobs to run your queries.

    http://msdn.microsoft.com/en-us/library/ms189237.aspx

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

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

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