In my environment we have 3rd party tool to monitor sql jobs and send us alerts when a job fails. Recently it's been acting weird and send us alerts after days. So I've been asked for an alternative solution.
The link below basically tells how to configure that SSIS Package but the steps are not clear to me on Step #2 where I need to add the dynamic OLE-DB connection to the package. When I right click on 'connections manager' console I don't see the option for 'Dynamic_SQLServerConn OLE-DB connection'. Can some one please modify that document with more detail information/steps please please. I wish DBA could stay away from SSIS. :-(
Thanks in advance