Successful SQL Server maintenance jobs have the following requirements for the SQL Server Agent Service:
-
Service must be active and running
-
Service must run under a Windows user account that has the appropriate permissions to perform duties on the DOC4000 database and server.
-
Ensure service runs under the Network Service (also known as NT Authority\Network Service) account,
-
Service should be configured to start automatically.
To check these items:
-
Open Windows Services and select SQL Server Agent in the middle pane.
-
Click More Actions > Properties in the right pane.
-
Set the Startup type to Automatic.
-
Set the Service status to Running.
-
Click the Log On tab.
-
Set the account to Network Service. If not already set, click the Browse button, add Network Service, and click OK.
-
Click OK to close the SQL Server Agent Properties window.