Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Job Ownership Article on SSC.Com

Today, Please see my featured article appearing on SQLServerCentral.com discussing SQL Agent Job Ownership.

Have you ever had a situation where a DBA or admin leaves the company, his login is disabled, only to discover that his years of service, and of creating sql jobs to run under his account, are now all suddenly failing? Backups, Maintenance Jobs, Packages, etc. 10, 20, 30, 40, 50 servers +.

What is the DBA left behind to do? That is the topic of this article and what you can do to automate and fix the issue accross your SQL Server infrastructure, and how to prevent it from happening in the future, using the scripts provided.

Please read on in Let's Talk Ownership (SQL Jobs)....
http://www.sqlservercentral.com/articles/SQL+Jobs/68764/

Thanks for reading!  Hope this is helpful  - RP

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.