Job step

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  June 26, 2003 at 6:54 am

  #59067

  I have a job which executes the following sql. Just wondering where is it getting the plan id from. Is it just a random number being generated. I also have database maintenance defined as category in the job.

  Any help will be greatly appreciated.

  Thanks

  EXECUTE master.dbo.xp_sqlmaint N'-PlanID 91E8D659-771A-4767-A609-2CE9E3C0E9C5 -To "USRUSTL_ADMN" -Rpt "C:\MSSQL\BACKUP\XXXDatabase\Output\XXXDatabase.txt" -DelTxtRpt 4WEEKS -WriteHistory -RebldIdx 100 '

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  June 26, 2003 at 7:06 am

  #463226

  Its from a maintenance plan - try running select * from sysdbmaintplans.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter