Monday, 25 November 2013

Microsoft Task Scheduler - Log on as batch job

We've got a daily task scheduled in Microsoft Task Scheduler on our main data warehouse server, which runs an old VB.script ETL once every morning.

As part of our current server migration, I've got to move this task to the replacement server. The current task runs using a service account and is set up to run regardless whether a user is logged into the server or not - you don't want the task requiring someone to be logged on!


When setting up a new service account user on the new server to run the task, I came across the following notification:


When I tried scheduling the job to run on the server with no one logged in, the task failed with the following error:

The reason for this error is that the user / service account that I am using to run the task requires 'Log on as batch job' permissions.

1. To resolve this issue, go to Administrative Tools > Local Security Policy snap-in.

2. Open the Local Policies tree under Security Settings.

3. Under the User Rights Assignment tree, right click on the Log on as a batch job policy:


4. Add the user/group that you wish to provide the Log on as a batch job permissions to.

Problem solved!

No comments:

Post a Comment