Page 1 of 1

View Schedule - problem

Posted: Wed Dec 04, 2002 2:53 am
by Bala
We are using Datastage 5.2 on Unix AIX
We have the follwoing peculiar problem.
- Assume that there are 2 IDs ( say ID1 and ID2).
- Both IDs are having scheduling permission for particular project.
- The ID1 has scheduled the ETL job @ 8:00 PM daily.
- When ID2 tries to view the schedule, the system shows the Job is [NOT scheduled] and allows ID2 to schedule for the scheduled Job.
That means that the system allows only to view the own scheduling for the job.
This is very strange and afraid that the whole processing will go wrong if the same job is scheduled & run at different timings by different IDs and this may lead to data/system crash.

So, please advice if anyone has a solution for this.

Thanks and Regards,
Bala

Posted: Wed Dec 04, 2002 11:01 am
by chulett
Yes, this is The Way It Works. What we do is use a single ID to schedule all of our jobs. Technically, we are a small enough shop that we use a single, DataStage-specific id when doing *any* Datastage work, including development and scheduling, so that we don't have issues of the sort you noted or others, like with permissions on hash tables.

-craig