• 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