Which account to use for running a scheduled tasks

Question

I am looking at creating a scheduled task to run a batch file that backs up SQL server Express each night. The script is fine but what I am sure about is what account to use to do this. There seems to be a few options, either System Local server or creating a user account.

Rather than creating a new account I was erring towards using the system account, are there any pro's / cons in doing this? or any better solutions.....

Answer 1

Hi,
The task should be scheduled to run under a service user account. Do not use a personal account, other than possibly temporarily for testing, since the schedule will stop working as soon as the password is changed.

Per searching, there are two old threads discussing on the managed service account of task scheduler.
What user account should we use for scheduled tasks on a server with sensitive material?
https://serverfault.com/questions/523701/what-user-account-should-we-use-for-scheduled-tasks-on-a-server-with-sensitive-m

How do I use a Group Managed Service Account with the Task Scheduler
https://social.technet.microsoft.com/Forums/windowsserver/en-US/42273a38-05dc-4f62-b915-8f55480d59bd/how-do-i-use-a-group-managed-service-account-with-the-task-scheduler

Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.

---

Hope this helps and please help to accept as Answer if the response is useful.

Thanks,
Jenny

Answer 2

As long as all the resources are local the system account should work file.

--please don't forget to Accept as answer if the reply is helpful--