I have always made Maintenance Plans in Sql Server, I have always done them in 2008 and now I have to do it in 2005. The problem is that I can not find in Sql Agent, how can I enable it? Or outright is not possible in this version of SQL.
I have always made Maintenance Plans in Sql Server, I have always done them in 2008 and now I have to do it in 2005. The problem is that I can not find in Sql Agent, how can I enable it? Or outright is not possible in this version of SQL.
SQL Server 2005 express does not include SQL Agent. You can check the documentation here . The relevant part is:
However, since SQL Server Express does not ship SQL Agent
(However, since SQL Server Express does not include the SQL Agent)
In any case, an alternative would be to create a bat file, execute it using sqlcmd and schedule it in the scheduled windows tasks.
SQL Server Agent is not included in the SQL Server 2005 Express version.
As an option you could use this development to create Jobs in SQL Server 2005 Express developed by Danillo Corrallo :
If you install the normal version, here is a guide how to enable it in SQL 2005 from the SQL Service Manager.