Post reply

SQL AGENT

  • June 30, 2008 at 8:31 am

    #129801

    Hi ,

    How can I manage remotely SQL Agent 2005?

    The sql server management studio express didn't manage it.

  • June 30, 2008 at 8:33 am

    #836161

    Tell me exactly what is the problem let me try to solve pls.

  • June 30, 2008 at 8:36 am

    #836165

    I want to manage the jobs, exactly how I did with sql 2000 (enterprese management), but with

    sql server managemnt studio express I can't manage the sql agent. I need to use TS to manage the jobs.

  • June 30, 2008 at 8:41 am

    #836170

    To manage jobs in 2005 go SMS and login and their we can find the sql server agent -> double click on that you can find their option like job

    just rt clk and new job u can create.

    next is job activity monitor to see all the jobs.

    Any doubts let me know.:)

  • June 30, 2008 at 9:00 am

    #836188

    Hey marcelo,

    Is that working let me know so that i can solve ur problem if not.:cool:

  • June 30, 2008 at 11:51 am

    #836290

    SQL Server Management Studio, is what you should be using to manage your SQL Server 2005 instance.

    SQL Server Enterprise Manager (SQL 2000) will not work over SQL Server 2005 Databases.

    Maninder
    www.dbanation.com

  • July 1, 2008 at 1:31 am

    #836470

    [font="Verdana"]Hi,

    You can get all the features in SSMS. Connect to SSMS and expand sqlagent to work with it. If Sqlagent is not listed in SSMS then you may be lacking privileges in msdb. Add your ID to SQLAgentOperator Role, this will do it.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply