December 20, 2007 at 6:22 am
We have DTS Packages that are scheduled to run nightly and show up in EM under JOBS under SQL Server Agent. A password got changed and some of the nightly jobs blew up.
Went into the Packages and entered the new password and successfully executed the packages BUT when I go back to jobs under the SQL Server Agent, the jobs STILL will not run - they fail with a login failure - as if i never fixed the DTS package. HELP
December 20, 2007 at 6:31 am
SQL Agent Jobs have an owner that must have rights to run a job. Look in BOL under Proxy accounts (SQL Server Agent).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 20, 2007 at 6:45 am
Thanks Much! The owner of the scheduled job DOES have permissions to run the job and the job won't even run when I change the owner to 'sa' the job worked yesterday and never failed before until the one password got change. Fixed the password problem in the package itself and it executes fine from there.. but it will not run from the actual job under the SQL Agent
December 20, 2007 at 6:55 am
Have you looked at the job steps? There are parameters/options in the call to run DTS that may include the changed password.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 20, 2007 at 7:03 am
Each job has only one step - to call the DTS package like this:
DTSRun /~Z0x637BDA8A5CC107EAB7CDD570EF3BDB20B17835A82DEEBD5FA3EFC7A495BB0DD3927C0AC7A940FBD355BB4641C5607CA3C06DB9596F621C7483A5E95FC19C03683199EABEA9F29EF54F50010751779A26C40958B2EB4E203960548E8C55AC1CF6D005D2D234869A4B7470F2E43B3F0C4297EABB12C481A4735875701973C0493807550FCB4204B73EE85F0AAD3A45AE445B5030B18833167F81B61E8D25016A878E066F
Do not see the password in the job steps themselves anywhere.. only in the DTS package itself - and I changed the password in the Packages.. very frustrating
December 20, 2007 at 10:24 am
Just an FYI. I had to drop the scheduled jobs and rescedule the packages in order for the scheduled jobs to run with the correct credentials. thanks for your help
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply