There should be a log file for SP4 (sqlstp.log or something, sort by recent files in /Windows). Check that more for more details. This is usually some error in starting...

YSLGuru,

I think you're on the right track, and despite the posts, it seems that you understand the issue. Don't worry about getting some good feelings from others. Go with your...

It looks like some sort of weighted average. Not sure. The denominator label throws me off. You really have

sum (count * average) / sum ( count)

I think you need to run this through a spell checker since I'm not completely sure what you mean here.

Can you run your stored procedures through SSMS? I'm not...

I like the solution above. It's much easier to work with this data inside SQL Server than it is during the import.

Jason,

Did you mean option 1? I tend to agree with you, though I might run a rollup each day looking for an overall look of what happened with jobs.

I'm confused as to why you are trying to execute step by step. I think that perhaps some of the structure of the package is getting lost by executing a...

LOL, nice reference, Grant. Grant's book is pretty good, as is the one he wrote on Execution Plans.

Don't see it on the McGraw Hill site either. My guess is that it's been delayed. I'd email the publisher.

You have two choices. One is enable email notification on completion of the job. This is changing the job, but not the command, just adding the notification.

The other is that...

Thanks for the repeat of the info, as I actually missed a touch there when I read through things.

Try not to get too defensive as many DBAs hear this question...

How does the .NET code connect? the login used, an the user mapped to it, need permissions to the proc.

a GRANT EXECUTE ON (proc) to XXX will work, but...

So you want to use dateadd to move your date to yesterday. Then if it needs to be 3pm, you need to do some casting. You will need to get...

I'd still do system backups. It isn't a catastrophic failure that's an issue. What if part of msdb becomes corrupt? Or someone removes a login/job/whatever? You don't want a VM...

I'm late, but I always have done daily master, msdb, model. Things rarely change, but they always seem to have changed right before something breaks. They're small, no reason not...