SQL Server Performance

sql server agent job history

Discussion in 'General DBA Questions' started by suniljk7, Jun 18, 2010.

  1. suniljk7 New Member

    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
  2. Luis Martin Moderator

    Did you check JOB folder?
  3. suniljk7 New Member

    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
  4. satya Moderator

  5. suniljk7 New Member

    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
  6. Luis Martin Moderator

    Folder like this:
    C:program FilesMicrosoft SQL ServerMSSQL.2MSSQLJOBS
  7. satya Moderator

    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.

Share This Page