Save credentials to execute scheduled tasks

2 posts / 0 new
Last post
idemnos's picture
Joined: 06/17/2016 - 13:25
Save credentials to execute scheduled tasks

I have managed to improve three queries to avoid input of data, because I need to automate those to generate data every first day of the month. I have a clear idea about what to do about windows schedule manager, but the problem comes with the following situation.
Everytime I need to import data and select the odbc connection, I need to provide my credentials (user and pass), by the way we use SYBASE.
Is there a way to save credentials in other place and load it to run the schedule task on windows?

Joined: 05/25/2018 - 02:33

hi idemnos,
Perhaps this link may help you.
Then put the connection string inside your script as shown in the picture.