Wow. Not a single response.

My post was either a really good one or a really bad one.

I think you can adapt this to work for you:

EXEC msdb.dbo.sp_send_dbmail

@profile_name='<the name of the profile you created in Database Mail>',

@recipients='<10 digit cell phone number>@txt.att.net;emailName@emailServiceProvider.com',

@subject='<any printable characters>',

@body='<any printable characters>'

I recently encountered a situation on a new server (SS2012) where I wanted an email notification if any SQL Agent job failed to execute to successful completion but could not...

This is not an explicit answer to your question but it may provide an acceptable work-around if you haven't already implemented it.

Right-click on "SQL Server Agent" in your SSMS GUI...

This is not a precise answer to your question but it might be worth considering.

I do a lot of reading and research on SQL Server, et al. I remember reading...

I use this script to check for failed SQL Agent jobs. You can easily modify it for 10 hours or whatever time interval you need to audit.

It's nothing fancy but...

No, I copied that segment of the job posting verbatim. It was from a job posting for a position at a college in Utah County, Utah, near BYU.

What can I...

Read it.

Thanks for the response, Gail.

You overstated the pay.

Yes, times are hard. Employees need to wear multiple hats.

Well, that's why I posted this, for corrections.

The scenario I thought I remembered was:

1. Log file full, database in read-only, suspect mode,

2. Disk full, no room for the log file...

I just ran across this one; I can't help but post it. This list is just part of the total job requirements:

Knowledge, Skills, and Abilities

- In depth knowledge and experience...

Thanks, Gail, and thanks, G-Squared, especially for the details regarding debugging SSIS problems.

SSIS is not one of my strong points. I'm going to tuck that advice away for future...

Jeff Moden,

Please clarify this subject for me:

I'm almost certain that I read somewhere that a "SELECT .... INTO #Table" would automatically create the target table, then lock the TempDB database...

Good idea. Lots to read. Thanks, Perry.

I was surprised to read the following:

" Database mirroring -This feature will be removed in a future version of Microsoft SQL Server. Avoid using...