how to make a new job in sql server 2005 and vista

ziorrinfotech used Ask the Experts™
i am trying to make a new job in my sql server 2005.
but in my sql server "sql server Agent" is diabled.
I am using vista.

how can i enable this and make a job in sql server
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
right click on sql server agent and click start



I did that but i am getting this error on vista
I am getting Access Denied error
and when  i went to the details
this is the error is i am facing
Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. (System.Windows.Forms)
AneeshDatabase Consultant
Top Expert 2009

seems like you dont have the sysadmin permission, you need to contact the administrator

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial