You got it right, even Microsoft push for this approach on ASP.NET. One SQL account, hidden for the user, for doing the job, and a table of users maintained by...

To schedule DTS jobs, I use a small utility , EZ Scheduler (free) from American Systems (www.americansys.com). By using this schedule program, the environment of the SQL server is preserved...