sql server 2008 - SQLServerAgent could not be started -


do know why have got error , how fix it.

sqlserveragent not started (reason: installation of sql server agent disabled. edition of sql server installed service not support sql server agent.).

my server parameters:

10.0.5500.0 sp3 express edition advanced services (64-bit) 

sql agent not available express editions : (http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx). that's why, example, can't schedule report production on reporting services.

you may want batch sqlcmd.

===== edit =====

simple sample:

save.sql ----- backup database dbname disk = 'somepath' init, format save.bat ----- "c:\program files\microsoft sql server\100\tools\binn\sqlcmd.exe"  -s instancename -e -i save.sql -o save.log 

you may schedule save.bat (with windows task scheduler) make full backup of dbname


Comments