We have several backup jobs on MSDE.

How do I monitor these jobs and get notified when a job fails. What are the
different notification possibilites with MSDE.

You can set this up in the jobs themselves. Look at the
notify_level options with sp_add_job in books online. You
can also find more information in the following knowledge
base article:
How To Back Up a Microsoft Data Engine Database with
Transact-SQL
http://support.microsoft.com/?id=241397

-Sue

On Fri, 14 Jan 2005 14:41:02 -0800, inquisite
<inquisite (AT) discussions (DOT) microsoft.com> wrote:

Now that I think of it....that article is not very good.
MSDE doesn't support SQL Mail so I'm not sure why Microsoft
has that in there as an option. And it also states if the
SQL client is installed that you can use Enterprise Manager
which is apparently an area of licensing confusion. So that
article basically tells you to do things that may not be
legal per the convoluted licensing issues with Enterprise
Manager.
If you want email notification, You can use XPSMTP instead
of SQL Mail, see
http://sqldev.net/xp/xpsmtp.htm

You can add additional step to your jobs to handle how you
want to do this. You can find more information at:
http://www.karaszi.com/sqlserver/info_no_mapi.asp

-Sue

On Tue, 18 Jan 2005 09:14:48 -0700, Sue Hoegemeier
<Sue_H (AT) nomail (DOT) please> wrote: