May 23, 2011 at 1:26 am
we are using sql server 2008 express edition.in that sql server agents are not installed how i install sql server agents?please give the suggetions
please see the attachment
May 23, 2011 at 2:13 am
Please don't post the question in many places.
http://www.sqlservercentral.com/Forums/Topic1113147-391-1.aspx
May 23, 2011 at 4:44 am
kishorechowdary.erp (5/23/2011)
we are using sql server 2008 express edition.in that sql server agents are not installed how i install sql server agents?please give the suggetionsplease see the attachment
You can't use sql server agents in express edition. You have to buy any other edition.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 25, 2011 at 1:49 pm
SQL Agent is not supported on SQL Express edition.
Depending on what you wish to do there is an alternative of using sqlcmd with windows scheduled jobs
Check out these link for more info:
http://jmkehayias.blogspot.com/2009/01/sql-server-2008-express-sql-agent-won.html
May 30, 2011 at 5:21 am
Use SQLCMD then create a batch script with SQLCMD and then schedule with Operating System Scheduler,SQLCMD is available with Express edition also
Usage of SQLCMD
http://msdn.microsoft.com/en-us/library/ms162773.aspx
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply