Saroj13
asked on
sql server agent job sent email notification for job success, failure , partial success? How this can be achieved?
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
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
momi_sabag
how about sending the emails from within the SSIS package itself?
ASKER
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
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
Hi,
You can use the SSIS Logging concept for the above requirement
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx
http://msdn.microsoft.com/en-us/library/ms167456.aspx
You can use the SSIS Logging concept for the above requirement
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx
http://msdn.microsoft.com/en-us/library/ms167456.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.