Ah! I remember seeing that before ... forgot all about it.

Thanks!

Nevermind, found it by profiling ...

EXEC msdb.dbo.sp_update_jobstep @output_file_name

Well ... I'm not to thrilled about it, but I changed it from one file per database to separate files based on YYYY_MM_DD_HHMM. Then when my daily backups come in,...

So specifying with INIT overwrites the entire file ... I thought it would only purge anything that fell outside of the RETAINDAYS ... hmm, I'm missing something obvious here.

I've...

Well, an easy way out would be to run a TLOG backup with INIT after my daily full ... but it seems like there should another way to accomplish this?

Yeah I figured as much, but this one just baffled me ...

After looking at how they created the system table, I was able to recreate it and repopulate it just...

Ok, I had to define a pager schedule ... and now it's working.

I feel smart.

Thanks for all the help!

So looks like by default you can't send emails to a phone as a page ... and the only way to receive a text message from SQL is via the...

Ok, exchange is now good. I can use database mail to send just fine.

Yet still not working for a notification operator. It works If I use the email notification, but...

Yeah talking to him now ... Looks like it is something they have to setup.

Thanks all!

Yep. The operator is set to My#@vtext.com. I've set the notification for both e-mail and page...

Indeed.

Kyle Neier (5/29/2008)

---

I use this feature regularly for SQL Agent jobs and it seems to work fine.

Set up your operator with the pager e-mail name of 5551234567@vtext.com. You can then...

Lynn Pettis (4/25/2008)

---

Adam Bean (4/24/2008)

And what do the indexes look like on tbl2 in this example above? The data being returned in the select, which tables are they from...

Same concept here ... scanning instead of seeking, no where clause, but on a join:

SELECT

NameType

,LastName

,FirstName

,MiddleName

,EndName

,NameKey

FROM tbl1 t1

INNER JOIN tbl2 t2

ON t1.NameKey = t2.NameKey

I've tried my index two ways:

CREATE NONCLUSTERED INDEX...