Steve Jones - Editor (4/2/2008)

---

Very strange. Have you tried a Profiler trace to see what's happening here? Maybe limit to the SQLAgent user to see if that's the one calling...

Ok, that worked. Email received:

DATE/TIME:4/2/2008 10:25:19 AM

DESCRIPTION:Error: 50001 Severity: 16 State: 1 Test error

COMMENT:(None)

JOB RUN:(None)

I can't say for certain what might have changed 2-3 days ago, but I'm unsure of whether the failure message worked fine before that, because the job wasn't failing before...

No worries.

Unfortunately, all of the jobs only notify on failure, and at this point, I can only see two jobs (still in the history) that have failed, and both are...

great news, thanks!

Yes, notify the default operator on failure

Yes, I know, that's why I'm confused... I don't see any reference to xp_sendmail

From my original post:

I've tested the exact statement in the stored procedure which sends the mail (exec...

bump...

Just wondering if anyone else out there can assist with a copy (or alternate location) of this?

Are you already pretty familiar with your way around Management Studio Express?

Thanks, that's pretty handy too, since it's not just a list of endless numbers without context. Better to use a temp table like you did, I think... although I...

I got it working. The only thing I changed was:

SET @string = 'USE ' + @dbname

EXEC @string

SET @string = 'blah blah blah'

to

SET @string = 'USE ' + @dbname +...

Matt Miller (4/1/2008)

---

Have you tried the new "reports" feature? Right-click on the database, pick Reports, Standard reports, "Disk usage by table". And voila - rowcounts (and much more)...

The last few lines:

FETCH NEXT FROM db_cursor INTO @dbname

...

When I change the PRINT back to EXEC, I get the following:

21307

0

21307

0

21307

0

21307

0

etc

etc

so somehow I'm not getting past the first database, even though I see that I am in the PRINT...

Possibly a corrupted MDAC installation?

http://support.microsoft.com/kb/307255/[/url]