| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2007-12-20 : 08:25:09
|
| 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 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-20 : 09:04:09
|
| Open the job and re-select the owner. |
 |
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2007-12-20 : 09:07:18
|
| Thanks. I went into the JOB and reselected the owner - still won't run. changed the owner to 'sa' still won't run. The DTS package runs fine when I execute it from local packages - it just won't run when I try to start the scheduled job from under the sql agent.. very frustrating. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-20 : 09:19:38
|
| Are the jobs running with DTSRUN /S /E /N or have you scheduled them from the DTS and the command line in the job step is in hex? |
|
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2007-12-20 : 09:42:39
|
| in Hex like this in the scheduled job: DTSRun /~Z0x637BDA8A5CC107EAB7CDD570EF3BDB20B17835A82DEEBD5FA3EFC7A495BB0DD3927C0AC7A940FBD355BB4641C5607CA3C06DB9596F621C7483A5E95FC19C03683199EABEA9F29EF54F50010751779A26C40958B2EB4E203960548E8C55AC1CF6D005D2D234869A4B7470F2E43B3F0C4297EABB12C481A4735875701973C0493807550FCB4204B73EE85F0AAD3A45AE445B5030B18833167F81B61E8D25016A878E066F |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-20 : 09:57:11
|
| Right, your problem is because the value would have changed. Set this to be:DTSRUN /S<yourservername> /E /N"<PackageName>" |
|
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2007-12-20 : 10:48:55
|
| like this? DTSRUN /S xxx.xxx.xxx.xxx /E /N "CycleErrorLog_DTS" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-20 : 16:17:39
|
| Did you save package after changing password? If still fails, you need recreate job. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-21 : 03:46:53
|
quote:
Originally posted by itsonlyme4
like this? DTSRUN /S xxx.xxx.xxx.xxx /E /N "CycleErrorLog_DTS"
If you are using IP Address then yes, else the name of the server. |
|
|
|
itsonlyme4
Posting Yak Master
109 Posts |
Posted - 2007-12-21 : 13:22:34
|
| Thank you! I ended up rescheduling the package which created a new scheduled job with the proper credentials - I then dropped the original scheduled job!!! |
|
|
|
|
Scheduled Jobs fail after password change