Post reply

Retrive the Jobs based on the SQL Server / SQL Agent Access avaible to the User

  • February 16, 2012 at 5:00 am

    #251736

    Hi All

    I am working on the SQL Server Agent Jobs.

    Issue here is that we can not afford for installation of SQL Server 2008 Licences for all.

    So we tried creating a VB application which will Initiate the Jobs using the VB app, which does not require any Licences.

    Now bottle neck is, how to display the Jobs based on the Proxy access / Agent access available to the User, who is using the Application.

    Thanks,

    Sudhir Nune

  • February 16, 2012 at 6:36 am

    #1447827

    Why don't you use one of the many SQL Server Agent replacements?

    - SQL ClockWork[/url]

    - SQL Scheduler

    - ExpressMaint[/url]

    - Standalone SQL Agent[/url]

    - Job Scheduler[/url] (Commercial)

    -- Gianluca Sartori

  • February 16, 2012 at 8:28 am

    #1447932

    Hi Gain,

    We can not use any open Tools because of IP Issue as you know, Can you please suggest if you are aware of using some other technique to Retrieve the job & Step List based on the user Access.

    Currently We are Displaying the Job & Steps using the MSDB.DBO.SYSJOBS & MSDB.DBO.SYSJOBSTEPS tables.

    Two issues:

    1. Every person need to have the Access to the above system tables.

    2. Every one can see all the jobs.

    Please need any pointer that can help.

Viewing 3 posts - 1 through 2 (of 2 total)

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