As stated in http://technet.microsoft.com/en-us/library/ms178127.aspxsp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'Agent XPs', 1;GORECONFIGUREGO
However the agent still would not start. After searching the event view, specifically the Windows Application log for errors and found the following
SQLServerAgent could not be started (reason: This installation of SQL Server Agent is disabled. The edition of SQL Server that installed this service does not support SQL Server Agent.).
Seems that if we want to have automated unattended jobs running, we will have to use power shell and Windows Task Scheduler. I am going to do some browsing and see what I can find out then have an update to this post on a workaround for those of us who use free edition.
The documentation does state that the SQL Agent is not included, I must have missed this link, check it out
http://msdn.microsoft.com/en-us/library/ms365248.aspx
You can create a SQL script and then run it in a batch file, once this works use task scheduler to schedule the task under a service account.
ReplyDelete