January 2, 2008 at 8:50 am
SQL Server 2000 Ent
A couple of weeks ago, a password got changed on a SQL login that 'broke' a couple of scheduled jobs. They were DTS packages that used this SQL Account that were scheduled and set up as scheduled jobs using the SQL agent.
Basically what I did was change the password in the DTS password to match the new password, reschedule the DTS package which created a new Scheduled Job under the SQL Agent and then I dropped the old (original) job that was failing because of the pasword change.
I thought I was good to go. the newly scheduled DTS packages are running fine but i cannot view the job history on any of these new jobs. When use EM and drill down to JOBS under Sql Agent and right click on any of these new jobs, it just says NO HISTORY AVAILABLE.....
Can anyone tell me what is going on with this and possibly how I can rectify it???
January 7, 2008 at 1:53 pm
Check if the job history is in the system tables.
SELECT * from msdb.dbo.sysjobs
SELECT * from msdb.dbo.sysjobhistory
Try recreating the jobs to see if you're still having the same issue.
January 7, 2008 at 2:13 pm
awesome! Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply