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
777 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CONVERT date time to a different time zone. 2 45
CROSS APPLY 4 45
the whoisactive update 12 39
Getting max record but maybe not use Group BY 2 17
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now