I had a couple of quick questions around SQL Server Agent and Database Mail. I am using SQL 2008
1. Other than setting up database mail, is there a more preferred way of being notified if a job (SQL Server Agent Job) succeeds?
2. How can you be notified BOTH if the job succeeds or fails? It seems like you have to choose one or the other.
3. Right now I have a job on each database server that loops through the databases on a given server and then backs it up to a network share for now. I have to have each job though on each database server though, is there a way to manage the jobs centrally so I don't have to setup the same job on each server?
Thanks as always..