![]() In the ERRORLOG file you’ll find a message that resembles to this: Error connecting to SQL Instance. When the service loses the connection to the target SQL Server instance, it won’t restart automatically and it will remain idle until you cycle the service manually. If you don’t have a SQL Server 2008 instance available, you can extract the definition of the stored procedure from the source code at CodePlex. I don’t know why this happens: I copied the definition of the stored procedure from a 2008 instance and it worked fine. In the ERRORLOG file (the one you find in the Standalone SQL Agent directory, not SQL Server’s) you’ll quickly find the reason of the failure: it can’t create the stored procedure sp_help_job_SSA. Easy peasy.Īs far as SQL Server 2012 is concerned, the service fails to start when connected to a 2012 instance. ![]() The UAC problem during installation is easy to solve: open an elevated command prompt and run the installer msi. It doesn’t restart automatically when the SQL Server instance starts.It’s not 100% compatible with SQL Server 2012. ![]() It fails to install when UAC is turned on.There’s no GUI tool to edit jobs or monitor job progress.It’s still a beta version and the project hasn’t been very active lately.However, while I still find it a great piece of software, there are a couple of downsides to take into account: It’s open source and it was started by a person I highly respect. ![]() This means that jobs, schedules and the like can be scripted using the same script you would use in the other editions.
0 Comments
Leave a Reply. |