SQL Server Agent Job Creation Through .NET

  • Dear Friends,

    I have one requirement in my present project,

    I have to create / delete / update SQL server agent jobs through NET 2.0 and i have to attach the schedule with that job. this also i need to with NET 2.0

    Any one of you woks on this?

    Please suggest me how do i do that

    The SQL SRVR Ver: SQL SRVR 2005 Enterprise Edition

    Thanks

    Anantha


    Kindest Regards,

    AnanthaMarella

  • Start Profiler.

    Open EM.

    Go to Maintenance -> SQL Server Agent -> Jobs.

    Create a new job similarto what you wanr to create.

    Go back to Profiler and find all scripts EM used to create the job.

    Change names, replace fixed values like Start Date, Recurency, etc. with variables and use it in your application.

    _____________
    Code for TallyGenerator

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

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