• Check the article I referenced above.

    Follow the instructions and create a subscription that will never run (set its run date to the past). It also explains how to get the job id (subscription/schedule id). Using that, you can execute the job (subscription) as needed via code.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg