And the other error looks like an application is using raiserror or something to throw a custom error message that may not be defined in sysmessages....

The SQLISPackage error is something out of an SSIS package. So you'll want to investigate the package for errors.

Are the service accounts the same? What was the exact error you got?

Yes. The easiest way is to go set something up like you want it in SSMS, then script out the alert.

And in terms of further automation, your best bet...

One for each severity level. Here's how to test:

--create an alert, using severity 9

EXEC msdb.dbo.sp_add_alert @name=N'RWTest',

@message_id=0,

@severity=9,

@enabled=1,

@delay_between_responses=0,

@include_event_description_in=0,

@database_name=N'master',

@category_name=N'[Uncategorized]',

@job_id=N'00000000-0000-0000-0000-000000000000'

GO

-- now add a message that...

The SQL Server Agent service account will definately need enough rights to restart the service, I just don't know if that's full administrator rights. For some reason this limitation...

Hi George,

Good point on the proxy usage.

As for the T-SQL, I see the code in the article for sp_add_proxy and the other stored procs, can you tell me more about...

Yes, unfortunately although these roles exist for the most part you need to be a sysadmin or the job owner to do anything useful.

By default the output in SQL Server Agent goes to the msdb.dbo.sysjobhistory table (that's what you see when you ask to view history from the job).

To get the...

Indeed - my mistake on the caption - it should say "Figure 3: New Database Mail Account". I'll get that changed.

RE:

In the "Review the Database Mail Logs", I think...

Indeed, looks like an editing error. I'll email the editors right away and let them know.... In the meantime I attached the correct screenshot here.