I don't know if this will help, but you could setup a job that sends you an email using xp_sendmail that has the query in the send mail script.

Schedule...

Due to recent issues we have been having, I would like a tool that could give us detailed information of what is residing in our MemToLeave area.

Having this information would...

Sorry, I just didn't catch on to the scripting part.  I understand why he suggested scripting now. 

When we changed our servers name we went directly to Sysjobs and made...

I am just curious!  Why would you have to script out all your jobs under SQL Agent?  

I have renamed a couple of my servers...

We were able to resolve this issue by configuring the MSDAINITIALIZE DCOM application to run as a specific local administrator account.

Start, Run, DCOMCNFG.exe

Component Services > Computers > My...

We changed the connection timeout and query timeout under the server options of the Linked Server, but that did not help.

Under the connection tab in the server properties, the remote...

Yes, we are.

We stumbled across something else this morning.  Here's the scenario: