For me, it's a two-fold issue... my password expires for SAP, AND it expires for the SQL Server database that I am extracting my Query script results into. I currently have 10 different scripts that I run (most are weekly), so when my pw expires every 45 days or whatever, I have to delete the existing scheduled jobs and re-create them with Studio, using the updated credentials. If this was something I only had to do once every 6 months or a year, not a big deal, but kind of a pain to have to deal with it every 45 days. I've been told to request an service account with a non-expiring pw (or one that changes once a year), but our IT is not typically eager to hook us up with such accounts (much less giving us the 'keys' to their login credentials) as they see it as somewhat of a security concern (not to mention you have to make sure that the service account has the appropriate table access behind the scenes).
------------------------------
Jeremie Dippel
Project Engineer @ Rockwell Automation
Wisconsin Local Wug Leader
I'm your huckleberry.
------------------------------