execute SQL Agent job from web form

Discussion in 'ASP .Net' started by Guest, Feb 26, 2007.

  1. Guest

    Guest Guest

    I have a web form and I'm able to list db servers and Job listed in the SQL
    Server Agent Job list, now my question is, how can I execute a .

    so for example

    dropdown 1 has all my db servers on my network.
    I can log into the selected DB from my web form.
    Then drop down #2 shows all jobs in the SQL Server Agent for the db server
    I'm logged in.

    I can then select a job, how can I get that job selected to Execute from my
    web form?
    Guest, Feb 26, 2007
    1. Advertisements

  2. Guest

    bruce barker Guest

    see system proc sp_start_job in msdb

    -- bruce (sqlwork.com)
    bruce barker, Feb 26, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.