[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

alert for job failure

Posted on 2009-04-20
2
Medium Priority
?
474 Views
Last Modified: 2012-08-13
how can you set up an alert for job failure in sql 2008. (e.g what error number, what severity)
0
Comment
Question by:david_32
2 Comments
 
LVL 8

Accepted Solution

by:
SNilsson earned 2000 total points
ID: 24190982
0
 
LVL 3

Expert Comment

by:mgmanoj
ID: 24301225
Did you tried using notification to send email or run the job to do the further necessary step ?  or are you looking for one step to monitor all the jobs on the server ?
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Screencast - Getting to Know the Pipeline
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

826 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question