SCheduled Jobs

Hi All,
I have many scheduled jobs running that creates a centralized database from
20 different databases in 20 different locations.
The jobs say they were successful, but the information is not coming over
all the time. If I manually run the job in EM, it works fine. Some of the
jobs call Stored Procedures and others are DTS packages. The jobs that call
SP's have between 3 and 20 steps in them, I check each job and all steps say
they were successful.
The DTS packages delete from the destination table and insert all records
from the Source. The DTS can have up to 4 tables being transferred.
TIA,
JoeHi
It is hard to say from your description what is wrong. Adding extra debug to
your processes may help and making sure that you are checking the error
status correctly in the stored procedures may show some unexpected events.
You may also want to profile the process to view what is really being
executed. Loading the data into separate staging table will allow you to
analyse the data that has been imported.
John
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:3817E52C-788E-4AEA-96A6-11E701AA44B3@.microsoft.com...
> Hi All,
> I have many scheduled jobs running that creates a centralized database
> from
> 20 different databases in 20 different locations.
> The jobs say they were successful, but the information is not coming over
> all the time. If I manually run the job in EM, it works fine. Some of
> the
> jobs call Stored Procedures and others are DTS packages. The jobs that
> call
> SP's have between 3 and 20 steps in them, I check each job and all steps
> say
> they were successful.
> The DTS packages delete from the destination table and insert all records
> from the Source. The DTS can have up to 4 tables being transferred.
> TIA,
> Joe
>