Solved

sql server agent job sent email notification for job success, failure , partial success? How this can be achieved?

Posted on 2012-04-10
4
790 Views
Last Modified: 2012-04-26
Hi ,

I have sql server job. Sql server job uses the ssis package. SSIS package reads the RawData from RawTable, parse the data and save the parsed data in the parsed table. This is done by using Script Task.

If there are some issues in parsing, suppose some records are not parsed, then those records will be saved in the log file. This is done by ssis package.

Sql Server Job sends the email when job is successful and when the job is failed.

I am not sure how to handle this situation:If there are some issues in parsing, suppose some records are not parsed, then those records will be saved in the log file. I want email is sent to dba that job is partial successful. How this can be achieved. How to notify by email in case of partial success??

Thanks
0
Comment
Question by:Saroj13
  • 2
4 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 37830415
how about sending the emails from within the SSIS package itself?
0
 

Author Comment

by:Saroj13
ID: 37830539
I want email
for
1 when ssis package success
2. when ssis package failed
2. when some of the records are not parsed, unparsed records saved in error log file, in that  case email will be sent for partial success...

how this can be done using ssis package
0
 
LVL 11

Expert Comment

by:SThaya
ID: 37831871
0
 
LVL 11

Accepted Solution

by:
SThaya earned 500 total points
ID: 37831883
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

839 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