Scheduled jobs fail after password change

[jpotucek]

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

 

[ptheriault]

I would try dropping the scheduled task and reschedule the DTS package with the new password.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[jpotucek]

Thank you much!!! I did that and everything is fine now.

 

[MSR63]

I had the same issue once and had to confirm that the services with the account that the password was changed have all been updated.

Also - before I made those changes I confirmed the job ran successfully (overnight)with the local account.

Once I updated the password - everything ran fine.

 

[jpotucek]

I thought everything was fine. All my 'rescheduled' jobs have been running fine... but all of the rescheduled jobs have NO JOB HISTORY when I write click on them (under sql agent) !!!! Any ideas??

 

[mrdenny]

They have no history at all, or no history since before you dropped and recreated the job?

If you are looking for the history from before you dropped and recreated the job that history is gone.

If you are missing current history then either another job has a lot of steps and it's running often, or your SQL Agent settings for job history are set to low.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jpotucek]

There is no history at all. I'm not looking for history from BEFORE the jobs were recreated - just History since. Some of the recreated jobs are daily, some weekly. How do I check the Agent settings for job history?

 

[mrdenny]

Right click on the SQL Agent, properties. One of the tabs will have the info you are looking for.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[jpotucek]

Max job history log size 1000 rows
Max rows per job 100.

 

[mrdenny]

That looks fine. Check out the other thread you started.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog