Post reply

T-SQL for a maintanence Plan

  • May 15, 2008 at 7:19 am

    #71594

    My ex coworker created a job that calls a maintenance plan. I'm trying to figure out how to generate the T-SQL statement for the plan.

    EXECUTE master.dbo.xp_sqlmaint N'-PlanID 35ec61d0-10bc-4be1-8d21-6a5e15cb5fe7 -Rpt "D:\MSSQL\BACKUP\LOG\All DB Maint4.txt" -DelTxtRpt 3DAYS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "D:\MSSQL\BACKUP" -DelBkUps 1DAYS -BkExt "BAK"'

  • May 15, 2008 at 9:06 am

    #815965

    Hi Jeff,

    Do you have a question?

    Greg

  • May 15, 2008 at 9:14 am

    #815968

    greg thanks for looking. I did, but I figured it out. I didn't realize that when you create a maintenance plan, it automatically generates that code. thanks again

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

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