Hi Jahid, You can't create job in SQL Server Express edition. Install some other edition of SQL Server.check following link. http://www.sqlservercurry.com/2011/11/sql-server-download-links-all-editions.html and http://msdn.microsoft.com/en-us/library/ms345154(v=sql.90).aspx

Fazal, I know i cant create the job in SQL Server Express edition. i want to know how to install sql server agent with my current sql express edition. and problem is in this express edition there are my more than 150 Databases. suppose i install new sql then what happened with my current database. i want to stay all my current databases and add feature sql server agent with it. Thanks for the reply.

Hello!

SQL Server Express does not ship with SQL Server Agent. So, when you say that SQL Server Agent service is running, I am not sure whether it is for the SQL Server express instance.

Since the Express does not support the SQL Server Agent, there is no way of installing it (by the way, the Management Studio that you reinstalled is just a client-side component and will have no effect on what services your SQL Server instance provides). You can search the Internet for 3rd party scheduling tools, however, note that they would not be supported by Microsoft, and therefore should not be used in production environments.

Hi Nakul Thank you for Reply

Jahid,

Since SQL Server Agent does not come with SQL Server Express Edition.

All you can do in the express edition is write stored procedures to do the job that you are looking for and make a batch job from windows scheduler. I have done this for database maintenance plan such as backup database, index rebuild, index reorg, etc.

Thanks a lot Abi Chapagai.

It is good option.

Jahid,

If one or more of the answers helped you resolve the issue, can you please mark the inputs that helped you as an "answer" so that it indicates that the issue is resolved.

Thanks for your sharings