March 26, 2006 at 3:54 pm
Hello all,
Really hoping someone may be able to shed some light on my problem...
When any job runs, regardless of the type of steps within it, the sysjobhistory and sysjobsteps tables in msdb are not being updated yet the sysjobschedule is being updated ....
Help!!!
Maree.
March 27, 2006 at 1:49 am
hmm .... have you checked SQL server agent's properties on Job System Tab ?? there might be some wierd values there.
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
March 27, 2006 at 3:16 pm
Thanks but the Tab looks fine. I've actually deleted some rows from the sysjobhistory table to under the 1000 limit just to check that's not the problem...weird isn't it?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply