Post reply

SQL Sever Job

  • September 7, 2008 at 11:26 pm

    #197404

    Hi

    I need to create a sql job via the SQL Server management studio console by means of which i need to fire a set of sql statements over a period of time.

    But i cant see any option of adding a job on the management studio console.

    Can you please guide me with this ?

    Regards

    Vijoy

  • September 8, 2008 at 12:08 am

    #868296

    Hello,

    In SSMS:-

    - Open up the Object Explorer

    - Connect to the required Database Engine (your SQL Server)

    - Expand the "SQL Server Agent" node

    - Right Click on "Jobs", and select "New Job"

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • September 8, 2008 at 12:18 am

    #868298

    Thanks John for a prompt response.

    My problem is i am not able to view the 'sql server agent' tab in my object explorer. I have connected to my DB but i just cant see the above tab to add my Job.

    Do i need to have some rights to be able to access this tab ?

    Awaiting your reply.

  • September 8, 2008 at 12:32 am

    #868300

    Hello,

    There is a dependency on your Server Role membership. Which one(s) do you have?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • September 8, 2008 at 8:40 am

    #868493

    Or maybe you have SSMS Express on your desktop.

  • September 8, 2008 at 9:42 pm

    #868834

    thanks so much John.

    I figured out that i had logged in with a user which didnt have the proper rights.

    I can see the JObs tab now !!

  • September 8, 2008 at 11:11 pm

    #868848

    Hello Vijoy,

    Thanks for the update. It is good to hear that the issue has been resolved.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • September 9, 2008 at 2:12 am

    #868886

    Can u please let me know which rights i need to take to get agent node in sql server 2005 mgmt studio

  • September 9, 2008 at 2:19 am

    #868887

    Hello,

    Please see the topic "Security for SQL Server Agent Administration" in BOL (SQL 2005 Books on Line).

    NB: If you are a member of the fixed SQL Server Role sysadmin then you will have access.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • September 9, 2008 at 2:22 am

    #868888

    Thank to reply

Viewing 10 posts - 1 through 9 (of 9 total)

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