The console application is written in C# and queries the database sending emails to various people depending on certain circumstances (document has expired or is to be reviewed soon).
I want to run it as a scheduled account, but it uses a trusted connection (so uses my credentials, which has access to the database). However, as passwords change every few months it would mean editing the task when I change my password.
How can I set a scheduled task to use the ASP.NET account instead? The server is Windows 2000 Advanced.