TwistedHelixis Posted January 9, 2017 Posted January 9, 2017 Hello, I took over a few schools from our LA and have just noticed that all of them have the SQL server agent set to disabled. I contacted the LA and they were not helpful. Everything seems to be working fine with Sims and FMS and the backups are all running but I am a bit confused as to why they would have disabled this service. The backups are called using a script. Should I just enable the service anyway?
Cazale Posted January 9, 2017 Posted January 9, 2017 Fairly sure it's disabled by default? I tend to leave things as they are if they work, at least until I need to make a change. 1
TwistedHelixis Posted January 9, 2017 Author Posted January 9, 2017 Fairly sure it's disabled by default? hmmm I thought it was on by default, but could be wrong. Anyone know what the default is?
SimonCygnetIT Posted January 9, 2017 Posted January 9, 2017 Default has been disabled with all the installs I have ever done.
matt40k Posted January 9, 2017 Posted January 9, 2017 SQL Agent is disabled (by default) in SQL Server Express as its not licensed. If you start it, it will just stop. You need SQL Server Standard (or higher) to use the SQL Agent. Most schools will just use Windows Schedule task to schedule a backup.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now