Well your sample data doesn't seem to match the data you described in your explanation order 5 is actually a new group and doesn't sum out to more than 10...

That is simply not what set language does, all it's doing is saying you want some specific localization like date names/formats etc...  It's not going to take some random text,...

Was the user account for some reason dropped and recreated?  Or someone or some process changed the account's access either way that's not an error.

I'll answer that a little differently, there can be performance value in pre generating a report especially if it's a report a lot of people pull up often.  Sometimes that...

Try logging in as the actual domain account you are trying to use and verify it can get to that directory, it's not about you logging into the server as...

Yes it will grow both DB and log files while the process is running, also if it fails it will not automatically free that space up back to the OS(or...

Why are you doing this in the second CTE your data already seems to be at 1 minute precisions?

DATEADD(MINUTE, DATEDIFF(MINUTE, 0, start_time), 0) start_time,
  ...

Generally what I want is a system that will tell me when there's an issue, what I do not want is someone sticking a "This job succeeded" notification onto the...

I've always worked at 24/7 companies.  That said when I worked at a small/medium sized company I was the only person who could support some of the critical systems *cough*...