Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to set the notification for sql jobs

Author  Topic 

boreddy
Posting Yak Master

172 Posts

Posted - 2011-03-16 : 05:59:06
Hi Experts

I have one job which runs daily and it contains the total 43 steps
in the first 10 steps belongs ssis packages are running
remining steps contain the sql scripts(sql statements)

all steps runs in this way
the current step is failed or successed it goes to next step

i want the notification for the sql script steps fails
for example
if my 20 step is faild i have to get the mail
in the same flow, 34 step is failed the i have get the mail


to do this what can implement in my job

Thanks in advance


sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-03-16 : 10:22:20
DB Mail is the best way.
get the information related to SMTP sever of your organization, and setup a DBmail. then in agent properties, you need to change the alerting to db mail. then in job properties set if the job failed send an email to your group.

Arnav
Even you learn 1%, Learn it with 100% confidence.
Go to Top of Page

boreddy
Posting Yak Master

172 Posts

Posted - 2011-03-16 : 10:57:52
Here is one problem

our job steps runs like this
if the step is failed or succes it goes to next step
this job returns the failure when it reaches to last step
i want the notification mail which step it is faild there itslef
othere steps should run

Go to Top of Page
   

- Advertisement -