What does the code do? What parameters does it take? I can see a couple of answers to this question depending on circumstances:
1. If the code in your ADP is something akin to a "batch" process that your users execute by clicking on a button, then you should be able to put this code straight into a SQL scheduled job (you really don't need DTS since one of the job types in SQL is ActiveX script. If you have parameters in the form that your users supply at runtime, you will need to have an alternate method for calculating these parameters.
2. If the code is doing stuff with data that is local to the users ADP environment, it may/will be a lot trickier. I would need more information if this were the case.
Note that in either case if the ADP code (should be what, VBA?) uses ActiveX objects that are unique to the user environment, you will need to register those objects on the SQL Server.
Have you hugged your backup today?