I will go ahead and give you one possible solution that I have been holding back on because I feel it would be a huge resource hog with the number...

Have you looked over the job owners, or server utilization at the time that some of these jobs fail to start.

And they definitely do not start, right?

Does this affect all 40 jobs or just some of the jobs?

Have you noticed any messages in the server logs (not agent logs)?

Is that on the 2000 or the 2008 instance that you see the null database name?

VoldemarG (2/6/2014)

---

<< I wonder if there is anyway whatsoever to distinguish these dupes from each other.>> well it is NOT KNOWN.

IT will take a while till we complete the...

Well, if you could answer the last part of my previous post, then there may be other possibilities that would be acceptable and not take excessive resources.

Robert klimes (2/6/2014)

---

try this out

$ds = New-Object system.Data.DataSet

$ds = Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -computer (Get-Content c:\computers.txt) | Select SystemName,DeviceID,VolumeName,@{Name="size"; Expression={"{0:N1}" -f($_.size/1gb)}},@{Name="freespace";Expression={"{0:N1}" -f($_.freespace/1gb)}}

foreach ($d in $ds)

{

$systemname = $d.systemname

$deviceID = $d.DeviceID

$volumename...

Possibly but I would wager that it won't.

Wow - ditto. Never seen that before and it is definitely...

Sean Lange (2/6/2014)

---

Ouch. An 800 million row heap?

Given that amount of data and that performance is going to be painful here is one idea.

Do a select distinct into a new...

ben.brugman (2/6/2014)

---

Thanks for the script, in the script I noticed a number of...

Thanks for the article.

I agree with Phil that the Title of the article seemed to be unclear in the intended topic.

I think the article would also benefit from better formatting....

Ed Wagner (2/6/2014)

---

BWFC (2/6/2014)

---

Sean Lange (2/6/2014)

---

Ed Wagner (2/6/2014)

---

SQLRNNR (2/6/2014)

---

Kill the...

You can try this code that may get some execution counts for the function you are investigating.

/* set the code text to be searched on with the variable @CodeName

*/

DECLARE @CodeName...

Kill the wabbit