Why do scheduled jobs run as network service?
Proto
Posts: 13 Bronze 2
in SQL Backup
I don't understand. Why bother setting up a specific account that the SQL Backup Agent runs under when scheduled jobs just ignore it and try and run under NETWORK SERVICE?
SQL Backup Agent is running under the SQLBackupAgent account, but that seems to make no difference.
It's permissions issue after permissions issue when setting up the latest version of Backup. I've never had so much trouble.
Is there a clear step by step guide on setting up Backup? Don't point me at that giant Permissions page, that is just a useless wall of text.
SQL Backup Agent is running under the SQLBackupAgent account, but that seems to make no difference.
It's permissions issue after permissions issue when setting up the latest version of Backup. I've never had so much trouble.
Is there a clear step by step guide on setting up Backup? Don't point me at that giant Permissions page, that is just a useless wall of text.
Tagged:
Answers
Warning 150: MAILTO error: SMTP host name not defined.
SQLBackupAgent has Admin permissions, but I suspect it's running as NETWORK SERVICE
which showed the email settings as blank, even thought they show in the UI.
went back to the UI and moved the port from 25 to 26 and back again to enable the Apply button.
Clicked that and now the settings are saved in the db.
Now scheduled jobs can find them and things run as expected.
So... weird