HI, I just created one maintenance plan for database check & I am not scheduled this Plan means it is in On demnad & I have checked for that one JOb is created in SQL which is enable with out any schedule.Upto this everything is fine. Now I create one job with multiple steps & one of the steps is executing the earlier maintenance plan(Chosse job Type SQL Server Integration Service Package).When I execute this Job this JOb is showing successfull & in Job history shows for maintenance plan step "Microsoft (R) SQL Server Execute Package Utility Version 10.50.4276.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 5:33:54 AM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 5:33:54 AM Finished: 5:33:54 AM Elapsed: 0.265 seconds. The package executed successfully." But when I checked the SQL Log or Maintenance History no where is showing that dbcc command executed & the steps is successfull with in zero seconds. Next I execute maintenance plan job which is created by default at the time of Maintenance plan creation.This jobs is executing successfully & same is logged in SQL Log & Manitenance plan history. Is any one have idea why this plan is not executing IF I call from other Job other than default JOb. My SQL Version is SQL Server 2008 R2 SP2. In net I have found someone else also having same problem but dont get any resolution or reason why it is not executing.
http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/b8286ea8-c0b8-4399-ac4d-9a43214d85d2/ Rgds Debasish