In my opinion

Small Database SQL Server (less than say 50GB)

Huge Database Oracle (anything more than 50GB)

I would

1. Send an email to those using the database inquiring if they are using the sa password for connection to the database. Advise them that the password...

As a work around I run the store procedure as a Operating System Command for SQL Server Agent, calling the store procedure using OSQL

osql -U dblogin -P dbpassword -S myservername\instance...