Page 1 of 2

NOT ABLE TO VIEW JOB SCHEDULES

Posted: Wed Oct 28, 2009 4:56 am
by vintipa
Hi Experts,

Few users are able to schedule the jobs but cannot view the schedule in the director.
That is, the job runs correctly once it is scheduled at any time, but when the View Schedule button is clicked, the jobs does not show the job schedule. It says (Not Scheduled).

It happens to few users but not all.

Kindly let meknow the reason and remedy to this.

regards,
vinay.

Posted: Wed Oct 28, 2009 5:52 am
by ArndW
Since DataStage uses the UNIX cron facility, I would look at the cron access rights, which can be a bit confusing at times.

Posted: Wed Oct 28, 2009 6:05 am
by vintipa
Can you please illustrate on this !!! i want to knwo what i should be checking

so that i'll check in this regard.

regards,

Posted: Wed Oct 28, 2009 6:59 am
by chulett
You need to understand that the cron-based Schedule is per user, so if user A schedules something, only they will see it in the schedule. Any other user will see it as 'Not Scheduled'.

Posted: Wed Oct 28, 2009 7:03 am
by vintipa
Ya but here the User A who has scheduled the Job is himself not able to view his Schedules...

Posted: Wed Oct 28, 2009 7:05 am
by ArndW
I think it is possible to have a crontab setup so that the user under whose ID the jobs are to run are not visible. Can you try to login in UNIX with that user's id and try "crontab -l"?

Posted: Wed Oct 28, 2009 7:11 am
by vintipa
this is the output i get :

$ crontab -l
0481-103 Cannot open a file in the /var/spool/cron/crontabs directory.
A file or directory in the path name does not exist.

any idia ?

Posted: Wed Oct 28, 2009 7:33 am
by chulett
You need to take that error to your SysAdmin so they can check things out and correct whatever the issue is.

Posted: Wed Oct 28, 2009 7:49 am
by mgendy
vintipa wrote:this is the output i get :

$ crontab -l
0481-103 Cannot open a file in the /var/spool/cron/crontabs directory.
A file or directory in the path name does not exist.

any idia ?

The System parameter crontab refers to invalid path , the file is missing , so the default privillages is that each user see his schedules , but i wonder how a user A couldn't see his schedules ? it is really strange , check with your system administrator , and kindly feed us back to know this strang behavior

Gendy

Posted: Wed Oct 28, 2009 8:11 am
by vintipa
Yes i am checcking this with the system administrators. at Unix level he has corrected all the permissions. But i guess there is some issue at Datastage level...

Actually i have created new projects and given "datastage developer" access to the group that contains this user.
rest all unix groups have "None" access

Posted: Wed Oct 28, 2009 8:21 am
by chulett
No, there's no "DataStage level" for schedules, it's all on the UNIX side.

Posted: Wed Oct 28, 2009 8:29 am
by vintipa
No but i wonder about this strange situation:
----------------------------------------------------------------------------------
user A is able to schedule jobs and view his schedule in a project P1.
But the same user A is not able to view his own schedules in project P2.

both P1 and P2 are in the same unix server.
----------------------------------------------------------------------------------

How can u explain this condition!!!
unix problem or datastage/ project settings problem?

Posted: Wed Oct 28, 2009 8:54 am
by ArndW
What does your project's "Schedule" tab in the Administrator tool say for both projects?

Posted: Wed Oct 28, 2009 9:03 am
by vintipa
The Schedule Tab is faded out.
in other words the tab is diabled.

what can this mean ?

Posted: Wed Oct 28, 2009 9:18 am
by chulett
It means you're not logged in as 'dsadm'.