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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2012-03-01 : 15:36:46
|
| Hello everyone.What is the best method to monitor agaent jobs using SSIS?RegardsRobs |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-01 : 15:59:14
|
| I can't think of a single reason to use SSIS to monitor SQL Agent jobs. Perhaps to report on historical run times, but not for monitoring. |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2012-03-01 : 16:05:38
|
| when i say monitoring, i mean to check on a number of agent jobs to see if they are successful or not? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-01 : 23:10:10
|
| why not log the status to a table and then pull a operational report out of it? Thats how we do it to check run status of jobs------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
monitor agent jobs via ssis