Re: No history information for jobs

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Prashanth L.V. (prashanthlv_at_yahoo.com)
Date: 03/18/04


Date: Thu, 18 Mar 2004 10:33:53 -0800

Hi Mark,

Thank you very much for your reply. The current setting of my sql server
is Max. job history log size(rows): 500000
max job history rows per job: 1000

Also, i dont understand why there is no job history for only some of the
jobs

Regards,
PRO

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Re: Replication -- subscriber job history does not appear on SQL server 2005 Subscriber from
    ... I have a small issue in looking at the the subscription's job history ... SQL Server 2000 publication. ... Replication Subscriber: SQL server 2000 Standard Edition(on Windows ... a message for each transaction (or one row for upto ...
    (microsoft.public.sqlserver.replication)
  • Re: DTS Problem
    ... Permissions are different when manual v scheduled. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > then in the job history i would see 'job was canceled'> ...
    (microsoft.public.sqlserver.dts)
  • Replication -- subscriber job history does not appear on SQL server 2005 Subscriber from SQL
    ... I have a small issue in looking at the the subscription's job history ... SQL Server 2000 publication. ... Replication Subscriber: SQL server 2000 Standard Edition(on Windows ... a message for each transaction (or one row for upto ...
    (microsoft.public.sqlserver.replication)
  • Re: Queue Reader Aborting. The step failed
    ... It sounds like SQL Server Agent couldn't start the queue reader job. ... Reader job\View job history ro see if there is any information there? ... > thing was that I could not restart it. ...
    (microsoft.public.sqlserver.replication)
  • RE: Deletion of Scheduled Job History.
    ... is the history empty? ... if the job history is not empty, ... the settings on the "Job System" tab of the SQL Server ...
    (microsoft.public.sqlserver.server)