Ok, thanks for all the wise advice - I'll stick with the scripting option and see how I get on.

Cheers!

I could do, although I seem to remember having mixed results doing it this way before....can't...

Thanks for all your responses - I think just copying the MSDB may be good advice, as in reality it's really only the jobs and schedules which would be the...

Actually I think I might have slightly misread you message...sorry! Yes that could potentially work I think?! Thanks!

Bhaskar.Shetty (5/24/2013)

---

In that case instead of setting notification, you can configure alerts, which can set whenever error fires, and notification can be set for job succeded instead of completed.

To Set...

The subject currently only includes the following:

"SQL Server Job System: 'Database_Backups.Subplan_1' completed on \\Server_Name"

I don't really want to change the notifications to only be sent when the job fails, as...

Hi - I'm still waiting for a callback from Microsoft but I will certainly give you an update once it's resolved...

The storage consists of separate RAID arrays with high speed discs for Data (4 discs RAID10), Logs (2 discs RAID1), Quorum and MSDTC (2 discs RAID1). The nodes are...

Thanks - I'll give SQLIO a try....I've head of it several times but never used it - that guide looks good though!

The irony is that the node that is slow...

Thanks Marbo - that looks like it might work!

Thanks guys - the job step type is actually Operating System (CmdExec)...not sure if there may be a switch I can add to that command to make it timeout? ...

I wholeheartedly agree....however unfortunately that is out of my hands! The job actually initiates backups using Netbackup, however when we do our weekly backups the job frequently runs for...

TheSQLGuru (10/31/2012)

---

1) Funny that you call this fairly simple. That is a beast of a query, with MANY joins, MANY CPU-burning operations (CASES, hash joins, aggregates,etc).

2) There is a...

Yeah I do too, although perhaps they were transferred from 2005 servers with later service packs on or something? Plus I still haven't found any other queries which run...

Just heard from the supplier who says they have replicated the problem at their end moving from a SQL 2005 server to 2008R2.

They have said it appears to be an...