<div>
This looks weird. Are you sure both the procedures are same only?<br />
And by any chance, are you using SET ROWCOUNT &nbsp;in the job with the procedure. This might be a reason for it to just update a certain number of records.
</div>


This looks weird. Are you sure both the procedures are same only?
And by any chance, are you using SET ROWCOUNT  in the job with the procedure. This might be a reason for it to just update a certain number of records.

<div>
I started from square one with the entire process and recognized logic added by someone else within the SSIS package.
</div>


I started from square one with the entire process and recognized logic added by someone else within the SSIS package.

<div>
<div class="content wysiwyg-content">
I have a stored procedure that I also execute via scheduled job. &nbsp;When I execute the stored procedure, all the records update and I get the correct result.<br />
<br />
When I schedule this same stored procedure to run via a scheduled job, every 30 minutes, all the records do not update as they do when I just execute the stored procedure in a query analyser window. &nbsp;Two or thre records at a time will update.<br />
<br />
We are usng SQL 2008. &nbsp;Has anyone else seen this behavior?
</div>
</div>


I have a stored procedure that I also execute via scheduled job.  When I execute the stored procedure, all the records update and I get the correct result.

When I schedule this same stored procedure to run via a scheduled job, every 30 minutes, all the records do not update as they do when I just execute the stored procedure in a query analyser window.  Two or thre records at a time will update.

We are usng SQL 2008.  Has anyone else seen this behavior?

Odd Job Behavior

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.