• There is a DTS task in SQL2000 to transfer jobs.  The source can be a SQL 7 server and you can select the specific jobs you want to transfer.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question