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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-10-04 : 17:54:45
|
| Some packages I develop have a lot of steps, and some people like myself can go crazy with email notifications, depending on the graph, I sometimes add notifications (success/fail) at the component level, so I can know what happened to that SSIS package from my blackberry and immediately log into the VPN and fix the issue. The only problem that I have with that is that sometimes, like right now, I see myself adding 6 "send mail tasks" to SSIS packages, one pass/fail for each component.Basically, I was wondering if anyone had any ideas or suggestions, ideally I wish I could create one single send mail task that could be reused by other components on the package and just update the message/subject through expression and variables. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 11:01:58
|
| Insert row(s) into a table that you can query instead. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 11:02:46
|
Clients are always wanting me to build things like "Send me an Email when a new order is placed"Me: "What about if you get 10,000 orders a day - because we build you a successful site"?  |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-10-05 : 12:04:51
|
| I have that (log table) in place for some processes, just that some of them, we need to monitor by email messages so we can take care of them before the business hours of the next day.Keep in mind that I'm lazy too, I don't want to log on the VPN to find out if the package failed somewhere... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 13:04:53
|
| Have an hourly job that Emails you to alert if there are NEW records in the table, then you know you have to go look to find out how many / what they are. But you won't get 1,000 emails a day ... all saying the same thing ... |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-10-05 : 13:26:03
|
| Ohh, OK, that sounds like a plan, thanks Kristen. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-05 : 13:38:44
|
| You ought to have it mail you each hour if there are any news one UNTIL you have viewed them.SO if Email fails for an hour you will still get an Email next hour ... until you preform some action (run the report and mark the "new" ones as Read, or somesuch)At least, that's what mine does!!Kristen |
|
|
|
|
|
|
|
|
Email Notifications