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?
hi idemnos,
Perhaps this link https://www.connectionstrings.com/sybase-adaptive/ may help you.
Then put the connection string inside your script as shown in the picture.
Regards,
Firdaus