<div>
With regard to the job execution less than 10 seconds, as you know, the gui won't allow this. &nbsp; You could schedule two job tasks offset by X seconds, but you need to be sure they don't overlap.<br />
<br />
You could also get around the SQL Server Agent scheduling problem by using windows:<br />
<a href="http://stackoverflow.com/questions/2809442/sql-server-job-with-precise-timing" rel="ugc">http://stackoverflow.com/questions/2809442/sql-server-job-with-precise-timing</a>
</div>


With regard to the job execution less than 10 seconds, as you know, the gui won't allow this.   You could schedule two job tasks offset by X seconds, but you need to be sure they don't overlap.

You could also get around the SQL Server Agent scheduling problem by using windows:
http://stackoverflow.com/questions/2809442/sql-server-job-with-precise-timing [http://stackoverflow.com/questions/2809442/sql-server-job-with-precise-timing]

<div>
<div class="content wysiwyg-content">
When running the LogRead.EXE instead of the SQL2k5 native Log Reader Agent UI, it appears that the System Monitor is not collecting the data points (the values are 0). Is there a way to collect these points?<br />
However, when the Agent UI runs we see the collected data under the SQL Server: Replication Logreader Delivered Cmd/sec and Trans/sec counters. Here is the sample command line that is being executed every 10sec via SQL Job scheduler. As an aside, if anyone knows a way to execute the SQL job less than 10sec via the SQL Scheduler - please inform on it too :)<br />
logread -Publisher S1 -PublisherDB DB1 -Distributor DB2 -DistributorLogin distributor_admin -DistributorPassword xxxxxxxxxxxx -MaxCmdsInTran 20000
</div>
</div>


When running the LogRead.EXE instead of the SQL2k5 native Log Reader Agent UI, it appears that the System Monitor is not collecting the data points (the values are 0). Is there a way to collect these points?
However, when the Agent UI runs we see the collected data under the SQL Server: Replication Logreader Delivered Cmd/sec and Trans/sec counters. Here is the sample command line that is being executed every 10sec via SQL Job scheduler. As an aside, if anyone knows a way to execute the SQL job less than 10sec via the SQL Scheduler - please inform on it too :)
logread -Publisher S1 -PublisherDB DB1 -Distributor DB2 -DistributorLogin distributor_admin -DistributorPassword xxxxxxxxxxxx -MaxCmdsInTran 20000

Activity not captured by System Monitor (aka perfmon) when using the Log Reader Agent command line execution

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.