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

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

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