You could always set the status notification to run every 5 or 10 or X minutes and check to see if the job status / last run date & time...

As I said, it sounds like the package hasn't "completed" when you're seeing the failure.

Can you attach a screen shot of the package when it's failed? I might be...

cRuchika,

FYI: I can't see whatever you posted in the scroll box.

Regarding a failed package but everything looks green or yellow? I've seen it before when a package has a task...

patwarimk (2/22/2010)

---

Hello, This is Praveen, Iam a tester and please can you give me some information while migrating Database from SQL Server 2000 to SQL Server 2008 what we need...

Thank you for this. I'm definitely voting on the connect item and will take a look at all suggestions as I really don't want to create a Gantt Chart Manually.

I did read the whole comment. It's just that the first paragraph of any email or post sets the tone for the rest of it. Which means your final comment...

Tom,

I understand...

I'm sure there are a lot of differences between your servers and mine, but this fix was a permanant fix for us. I've had it in affect for almost 2...

Precaution and dropping / recreating your maintenance plan are your only two solutions for now.

Unless it's included in SP2 or the SP1 Hot Fix, no. We don't have it applied to our clustered servers.

Of course, the initial solution I posted worked for us, so...

mirde (1/15/2010)

---

... basicly what I tried is "backing" it up and then I created a new DB and tried restoring to it. this did not work well, the error message...

Caveat - I am using Litespeed for my backup maint. plans.

However, I have had the same issue. If I delete a database *before* altering the plan, the plan no longer...

Now, see, I've never heard of xp_DirTree before now. And for a moment, I actually considered changing the code I had to use it.

And then you spoiled it with...

Ah, but your response gives me a lot more information than I had before. Now I know what to look for and how to reconsider the partitioning idea.

Thank you.

And the user db is on the same drive or a different drive? How much space does it have available to it and is its Autogrowth set to Unlimited?

Run the...