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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-10-29 : 02:14:22
|
| Dear team,we have created ssis package to loading data from source to Destination.we have created ssis packge to load the data. and we were created Sql Agent Job (4-Steps).each step is a ssis package .out of 4 steps any one step is failed mail Sholud go Techinical pesorns throuh mail.so how activate this mail alert process,anybody knows pls explain me the way . |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-29 : 09:49:45
|
| you can configure this in SQL AGent job properties. Go to Notification tab and in action select option to sent an email in case of job failure.Otherways to add notification inside each package or use a control table to log job steps and check it and send email in case of failue using t-sql script as an additional step in job------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-10-30 : 03:38:20
|
| Dear team thx for reply. in sql agent job properties-->notifications-->i have selected email text box.i am getting 3 acaions(jobsuccess,fail,completed).sowhere i have to mention require mail id.case 2 :how to add the notification inside package and pls provide the t-sql script.pls explain breifly. |
|
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2012-10-30 : 04:49:16
|
| You mentioned for FAILED case....each step is a ssis package .out of 4 steps any one step is failed mail Sholud go Techinical pesorns throuh mail.So you have to select fail action ( in the first case)--Chandu |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-30 : 09:45:57
|
quote:
Originally posted by kond.mohan
Dear team thx for reply. in sql agent job properties-->notifications-->i have selected email text box.i am getting 3 acaions(jobsuccess,fail,completed).sowhere i have to mention require mail id.case 2 :how to add the notification inside package and pls provide the t-sql script.pls explain breifly.
Notification inside package is added by means of Sent Mail Taskseehttp://www.mssqltips.com/sqlservertip/1731/sending-email-from-sql-server-integration-services-ssis/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql Agent job fail have to get mail alert