I try to avoid hardcoding passwords in stored procs. The safest route in my experience is to run SQL Server or the job under a domain account that already has...