DSXchange

Hi All,

I need to unscheduled a sequence from Director which is scheduled by another user. I am not able to see the schedule, hence I cannot unscheduled it. Could you please help me?

Does anyone have elevated privileges on the server itself? Unless the architecture has changed, they're just crontab entries so technically someone with permissions could go in and edit / empty their crontab entries. There may also be an equivalent in Director.

Thanks Craig,

We did it in the same manner. Deleted the crontab entry.

The person with admin privilege could not see the entry in Director. Any reason why this can not be handled through DataStage?

That would be a support question. In all the times I used it on a Unix system it simply read the crontab entries for the logged in user, perhaps they've added something to handle it differently? I not know.

In DataStage Director you right click on the scheduled job, then choose Unschedule from the context menu.

Ray, are you saying that will work for someone who is not the original scheduling user? Because that's the question at hand.

Ray,

The option that your are suggesting is working for the user who scheduled the jobs but if someone else is scheduled then not able to view the schedule for other user.

We asked an user with root prov to edit the crontab entry and that worked.
Wondering why we are not able to view scheduled jobs done by other users.

Is everyone in the dstage group, and is the dstage group recorded in cron.allow and at.allow?

Hi Ray,

No, not everyone is in dstage group. We checked under /etc/var/spool/cron folder and found all the users that have cron entries. We changed permission by using chmod -R 775 and then edited the cron entry of the specific user whose entry was to be deleted.

What is cron.allow and at.allow?

We were asked to check cronjobs or atjobs entries.

The cron.allow file specifies which non-root users are permitted to use the cron command, while the at.allow file specifies which non-root users are permitted to use the at command.

That said, I'm not sure that DataStage 11.x still uses cron and at for scheduled jobs. It may be that the Information Server scheduling service is the culprit. Check with IBM about how to configure that.

The 11.x scheduling behavior is the same as ever. If you want to unschedule a job from Director, then you must log into Director as the user who scheduled the job in the first place. Simple as that.

Figured.

If the user is not available then is there any option available from director to unscheudle it logic as a admin user ?or only option to edit the crontab entry?

From Director, an admin user, again, can only unschedule their own jobs--only the jobs that they themselves scheduled. In Director, no user can unschedule any other users' jobs.

The only option in that case is at the operating system level through root access or sudo root access, is as you mentioned, to edit the other users' crontab or at entries.