question

user-806 avatar image
user-806 asked

Issues With MaintenancePlan

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
jobs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
Did you get this figured out?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

user-806 avatar image user-806 commented ·
Not yet.It may be a bug.I am not sure.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.