SQL Server Performance Forum – Threads Archive
Maintanamce plansHi guys is that possible to create maintanance job in sqlserver 2005 because i am trying ot create maintnance jon for reindexing but it is not creating. thanks in advance. SRJ2005
Yes, it is possible and in sql server 2005 maintenance plans uses SSIS package (BI studio) not like in sql 2000 using .exe. MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
You have to more clear about ‘…its not creating’, are you getting any error or unable to create the MP itself. Take help of SQL 2005 books online about creating MP in this case, there is much available information out there. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
reethu: as per MohammedU post above: First, make sure the ‘SQL Server Business Intelligence Development Studio’
Start->all programs ->Microsoft SQL Server 2005->’SQL Server Business Intelligence Development Studio’ if it is there: How to: Create a Maintenance Plan
SQL Server MVP, MCDBA, OCP
yes you are right i did fix it thanks. SRJ2005