And this is the second post of today, only a quick link to a great script from SQLFool. That girl is really a script junkie – and I love her scripts.
http://sqlfool.com/2012/09/sql-agent-job-script-2/
It is extremely useful to be able to monitor all your jobs from within a single place. I’ll set up some scenario like this and come back with more instructions later. Enjoy the script for now.
cya in 2 weeks. bye.