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
812 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

631 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