I have about 25 files that I need to move from universe to SQL Server 7.0. Is there any limit that I should be aware of as far as how many I can do in one job. Should I break this into multiple jobs or just one big one?
Thanks,
Mike Roosa
Getronics
Number of Items in Job
There is a limit of (IIRC) 128 links per stage instance, and a limit of (IIRC again) 8192 links in a job. This wont affect the numbers youre talking about. You can use one job (presumable with parallel paths) or multiple jobs (possibly run by a controlling job). Its your call. My personal preference would be the multiple controlled jobs, because the controlling job can more easily interrogate (and record) results from the controlled jobs.
> ----------
> From: Roosa, Mike[SMTP:Mike.Roosa@getronics.com]
> Reply To: informix-datastage@oliver.com
> Sent: Wednesday, 30 August 2000 00:25
> To: informix-datastage@oliver.com
> Subject: Number of Items in Job
>
> I have about 25 files that I need to move from universe to SQL Server
> 7.0. Is there any limit that I should be aware of as far as how many I
> can do in one job. Should I break this into multiple jobs or just one
> big one?
>
> Thanks,
> Mike Roosa
> Getronics
>
> ----------
> From: Roosa, Mike[SMTP:Mike.Roosa@getronics.com]
> Reply To: informix-datastage@oliver.com
> Sent: Wednesday, 30 August 2000 00:25
> To: informix-datastage@oliver.com
> Subject: Number of Items in Job
>
> I have about 25 files that I need to move from universe to SQL Server
> 7.0. Is there any limit that I should be aware of as far as how many I
> can do in one job. Should I break this into multiple jobs or just one
> big one?
>
> Thanks,
> Mike Roosa
> Getronics
>