Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jshurak
Starting Member
44 Posts |
 Posted - 2008-05-15 : 09:06:07
|
| I'm looking at a job my old coworker created that calls a maintenance plan. The T-SQL is as follows: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"'how was this code generated? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 10:12:22
|
| From maintenance plan. |
 |
|
|
jshurak
Starting Member
44 Posts |
Posted - 2008-05-15 : 10:19:45
|
| sorry, figured this out. I didn't realize that the maintenance plan automatically generates a job that includes the t-sql. I was using SSMS and didn't have the option of creating a maintenance plan on a 2000 box. Switched over to EM and created a new plan and saw the job gets automatically created. thanks for helping though! |
|
|
|
|
|
|
maintenance plan scripts in jobs