Hi all, I am facing an issue on sql server 2000 with sql agent job history. below are the details Box- Windows 200 server Sql server 2000 with sql4 Only one instance (default) We have configured around 80-100 job on this instance all the jobs areexecuting successfully, but no job history is getting created. not evena single entry in msdb..sysjobhistory. I have increased the Maximum jobhistory log size and all, but i don't this is an issue here because wedon't have a single entry. also we have rebooted the server still theproblem exist. Pleae help me on this, we urgent. Thanks John
sorry for the delay.. i was not able to access for some days which job folder you are telling? OS job folder? no i did not check, what i have to check there John
What kind of stored procedures you executed to obtain job history? Get the script about list job run history from here; http://searchsqlserver.techtarget.com/searchSQLServer/downloads/sp_ListJobRunHistory.txt or even you can run SP_HELP_JOB_HISTORY to obtain the information.
There are about 35 jobs.. all kinds of jobs are there.. perging, maintenance jobs..data moving jobs..and its all running without error..how i make sure its running means its perfoming the task.. (because there is no history of success or failure i make sure to check in table and index etc) Thanks John
Right click on SQLAgent properties and read the SQLAgent log for any warning/error based information. Also check the settings for SQLAgent on job history.
