Steve, it would be nice if you could always anticipate all my system problems and post an article beforehand. One week, not bad! Nice work, thanks.

The job history went to a "Performing completion actions" state until I actually cancelled the job. In other words, it just hanged at the point of failure.

The job is an...

I didn't see the timeout setting there. But unfortunately, it is already unchecked (and the value is 0 and grayed out). The timeout settings I referred to where in the...

Oh crap, I should've tried it first. The general setting doesn't stick either. I tried changing it to 9999 but nope. How do you change it?

Yep, SQL2k SP2 and AS SP2. Does that mean a value of 0 isn't "no timeout"? I suspect the problem isn't the connection timeout but the general timeout anyways....

I'd suggest that you run profiler and see if EM is sending anything to SQL Server. For restore information, SQL has to query the msdb database. There you could see...

Not sure if this is the case but any DTS task without a precedence task will start immediately. So, it's entirely possible for multiple tasks to run concurrently. Now if...

I think the more nested your packages get, the more possibility of error, AS or not. Basically I am doing the same thing -

Job A:

Step1 - Run ETL package

Step2...

Yeah, the doc is rally lacking. I love <heavy sarcasm> the description of the AS properties settings. Really tells you a lot. We had a consultant come in and tweak...

Could be cached but seems unlikely. We have had a problem with some status emails never getting sent out (which is the next step after these tasks). This has been...

Sounds good in theory. AS manager lets you add the same fact table as a dimension table. However, I suspect that it will try to do a self-join when retrieving...

To archive:

In AS manager, right click the olap database and select archive database. etc...

To restore:

In AS manager, right click the server and select restore database. etc...

You can also use the...

Ask them to name a few bugs in SQL Server. If they can't name any, they haven't worked with SQL Server outside of their tutorial CDs!

I think we'd all still have jobs - just that we'd spend our time doing something productive rather than fixing random odd nonsense problems. BTW, I've just come upon yet...

Hi, back from vacation, sorry for the lack of reply. Basically, there was no hang anymore, the query was just taking much longer for some reason after the upgrade. After...