It's a symptom of the "something for nothing" society that we live in these days. Kids don't want to buy a ticket to go to the movies, anymore, because...

Mays: "Why not create a detailed Maintenance Plan?"

We already do that. We want to get away from that.

We do Optimizations only once per week (during the slowest times for...

I can't use a job with multiple steps. We want to run multiple DB Maint tasks in sequence (e.g. IntegrityChecks then Optimizations then DbBackups) and if one task fails...

Thank you but, if you notice the date, I solved this problem THREE AND-A-HALF YEARS AGO.

Have a nice day.

Animal Magic -

SQL Agent appeared to be running in my SQL Management Studio, but I could not stop it. When I checked the server box, itself, I discovered that...

peter -

There was nothing in the SQL Error logs, because the jobs were not errorring out.

People, my original post is more than 1 year old. You do not need to respond, anymore.

Thank you.

Cath,

Unfortunately we do not set up our SQL Servers with OLE Automation, so the script is not usable for us.

Thanks, anyway.

I've been working on other server builds and haven't had a chance to really dig into this, yet. I'm not sure I'll be able to use a non-TSQL solution...

kunal, thank you for your reply. We have already looked at all of the obvious causes tried all of the obvious fixes and they didn't work, which is why...

Andrew: Thank you for your reply. No, it does not apply. My message says "duration" of a single update stats maintenance execution, not the time interval between separate...

Yes, it does.  However it discusses it using an Execute SQL Task.  There are reasons I cannot use an Execute SQL Task.  I need to do it using an ActiveX...

I'm sorry, I should have been a little more explicit in my question.  I need to call the stored procedure from, and return the stored procedure output parameter value to, an...

Sergiy,

Since the execution times of the two queries are essentially the same, do you want me to tell you what the real difference is between our two queries?  Simplicity.

If you look...

Sergiy:

Just thought you might like to know...

Out of curiosity I tested both your and my code on a real table in one of the databases I work with.  I returned...