• A question about permissions.

    When I schedule the job, because it will run using SQL agent service account, it won't work because it cannot login to other computers using that service account to check disk and db size.

    So I created a proxy account using my own credentials, for I am a dba, so I have access to those servers that I need to check.

    Is that the right approach to go? I mean for the account that run the SQL job - it has to be sysadmin on all those servers that need to be checked, correct?

    Thanks