Post reply

Creating Maintenance plan to run annually

  • June 17, 2025 at 10:22 am

    #4608859

    What is the best way to set the schedule of a maintenance plan or a SQL Agent job to run annually. We need to move data to an archive database for a table end of each year for the oldest year. I have the scripts all ready but the scheduling is the issue. For this table it will be in January but in future I may need to do this on other tables where the Financial year starts in July.

     

    Any assistance will be appreciated.

  • June 17, 2025 at 1:26 pm

    #4608944

    AnnualSqlJobDialog

  • June 17, 2025 at 3:13 pm

    #4608999

    Thanks, totally missed that

  • July 10, 2025 at 8:46 am

    This was removed by the editor as SPAM

  • July 10, 2025 at 8:47 am

    This was removed by the editor as SPAM

  • July 10, 2025 at 10:02 am

    This was removed by the editor as SPAM

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

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