NOT ABLE TO VIEW JOB SCHEDULES

vintipa · Post by **vintipa** » Wed Oct 28, 2009 4:56 am

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.

ArndW · Post by **ArndW** » Wed Oct 28, 2009 5:52 am

Since DataStage uses the UNIX cron facility, I would look at the cron access rights, which can be a bit confusing at times.

vintipa · Post by **vintipa** » Wed Oct 28, 2009 6:05 am

Can you please illustrate on this !!! i want to knwo what i should be checking

so that i'll check in this regard.

regards,

chulett · Post by **chulett** » Wed Oct 28, 2009 6:59 am

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'.

vintipa · Post by **vintipa** » Wed Oct 28, 2009 7:03 am

Ya but here the User A who has scheduled the Job is himself not able to view his Schedules...

ArndW · Post by **ArndW** » Wed Oct 28, 2009 7:05 am

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"?

vintipa · Post by **vintipa** » Wed Oct 28, 2009 7:11 am

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 ?

chulett · Post by **chulett** » Wed Oct 28, 2009 7:33 am

You need to take that error to your SysAdmin so they can check things out and correct whatever the issue is.

mgendy · Post by **mgendy** » Wed Oct 28, 2009 7:49 am

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

vintipa · Post by **vintipa** » Wed Oct 28, 2009 8:11 am

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

chulett · Post by **chulett** » Wed Oct 28, 2009 8:21 am

No, there's no "DataStage level" for schedules, it's all on the UNIX side.

vintipa · Post by **vintipa** » Wed Oct 28, 2009 8:29 am

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?

ArndW · Post by **ArndW** » Wed Oct 28, 2009 8:54 am

What does your project's "Schedule" tab in the Administrator tool say for both projects?

vintipa · Post by **vintipa** » Wed Oct 28, 2009 9:03 am

The Schedule Tab is faded out.
in other words the tab is diabled.

what can this mean ?

chulett · Post by **chulett** » Wed Oct 28, 2009 9:18 am

It means you're not logged in as 'dsadm'.