Home Forums SQL Server 2005 Administering Jobs logged in the "Job Activity Monitor" but not in the "View History" RE: Jobs logged in the "Job Activity Monitor" but not in the "View History"

  • February 20, 2013 at 8:23 am

    #1589582

    fasttrack (2/20/2013)

    SQL Server 2005 Enterprise Ed,

    Hi guys,

    I have the following issue:

    There are some jobs running successfully. The execution is reported in the "Job Activity Monitor" highlighting the "Last execution" and "Next Execution",

    This data comes from msdb.dbo.sysjobactivity and there is at least one row in that table for every job.

    but if I click on a specific job and select "View History" I do not see nothing (no filters are applied).

    This data comes from msdb.dbo.sysjobhistory and there is not always a row in the table for every job/step.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato