Scheduling jobs from Director

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Scheduling jobs from Director

Post by admin »

Hi all,
i have problem on visualize schedule from the director.
Im working with DS 4.1 on AIX 4.3.
A try to schedule a job to run Today at a specified time from the director but it looks like unschedule in the director. The strange thing its that: i controled the processes scheduled by the at command and the job was correctly scheduled. An other strange thing its that if i schedule a job to run Daily or Every the director seems work aright.

Someone can help me about this?

Thanks all.

Riccardo Tani
Staff Consultant
Direzione Industria e Servizi
Datamat, Enabling Your Future
Rome, Italy
e-mail: rtani@datamat.it
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Salve Riccardo,

What is the exact version of DataStage that you are using?
You can find out by viewing the following file:
$ cat $(cat /.uvhome)/.dsrel

This could be an existing issue, however, if you try to
schedule the job directly from "at" you will not see it
scheduled in Director, as you know.

This does sound like an existing GTAR. However, have you checked that the user you are testing with is the same one used in both the Director and the commandline?

When you schedule from Director, DataStage will end executing either the "at" or "crontab" commands at the Unix level. You could put an "interlude" script for the "at" command in
this case to trap the command that DataStage director executes.

Try the following script:
#! /usr/bin/ksh
CMD=`basename $0`
echo ${CMD} $* >> /tmp/${CMD}_$$.log
/usr/bin/${CMD} $*

Name the above script "at" and place it higher up in the search
path. For example place it in the /usr/local/bin directory and then edit the dsenv file so that /usr/local/bin is the first directory in the PATH.
PATH=/usr/local/bin:$PATH; export PATH

You will need to stop and start DataStage for the dsenv changes to take effect. Then when you schedule the job from Director a log file will be created in /tmp named "at_NNNN.log" where NNNN is the PID of the process that called the script.

I hope this helps in some way.

Best regards,
Anthony Corrente.

--- Riccardo Tani wrote: > Hi all,
> i have problem on visualize schedule from the director.
> Im working with DS 4.1 on AIX 4.3.
> A try to schedule a job to run Today at a specified time from the
> director but it looks like unschedule in the director. The strange
> thing its that: i controled the processes scheduled by the at command
> and the job was correctly scheduled. An other strange thing its that
> if i schedule a job to run Daily or Every the director seems work
> aright.
>
> Someone can help me about this?
>
> Thanks all.
>
> Riccardo Tani
> Staff Consultant
> Direzione Industria e Servizi
> Datamat, Enabling Your Future
> Rome, Italy
> e-mail: rtani@datamat.it
>

_____________________________________________________________________________
http://messenger.yahoo.com.au - Yahoo! Messenger
- Voice chat, mail alerts, stock quotes and favourite news and lots more!
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Salve Anthony,
Thanks a lot for ur help.
The Datastage version is 4.1.1 and the user is the same used in both the Director and the commandline. Ill follow ur suggestions and i will keep u informed about risults.

Regards,
Riccardo Tani
Staff Consultant
Direzione Industria e Servizi
Datamat, Enabling Your Future
Rome, Italy
e-mail: rtani@datamat.it

----- Original Message -----
From: "Anthony Corrente"
To:
Sent: Monday, July 02, 2001 11:44 AM
Subject: Re: Scheduling jobs from Director


> Salve Riccardo,
>
> What is the exact version of DataStage that you are using? You can
> find out by viewing the following file: $ cat $(cat /.uvhome)/.dsrel
>
> This could be an existing issue, however, if you try to schedule the
> job directly from "at" you will not see it scheduled in Director, as
> you know.
>
> This does sound like an existing GTAR. However, have you checked that
> the user you are testing with is the same one used in both the
> Director and the commandline?
>
> When you schedule from Director, DataStage will end executing either
> the "at" or "crontab" commands at the Unix level. You could put an
> "interlude" script for the "at" command in this case to trap the
> command that DataStage director executes.
>
> Try the following script:
> #! /usr/bin/ksh
> CMD=`basename $0`
> echo ${CMD} $* >> /tmp/${CMD}_$$.log
> /usr/bin/${CMD} $*
>
> Name the above script "at" and place it higher up in the search path.
> For example place it in the /usr/local/bin directory and then edit the
> dsenv file so that /usr/local/bin is the first directory in the PATH.
> PATH=/usr/local/bin:$PATH; export PATH
>
> You will need to stop and start DataStage for the dsenv changes to
> take effect. Then when you schedule the job from Director a log file
> will be created in /tmp named "at_NNNN.log" where NNNN is the PID of
> the process that called the script.
>
> I hope this helps in some way.
>
> Best regards,
> Anthony Corrente.
>
> --- Riccardo Tani wrote: > Hi all,
> > i have problem on visualize schedule from the director.
> > Im working with DS 4.1 on AIX 4.3.
> > A try to schedule a job to run Today at a specified time from the
director
> > but it looks like unschedule in the director.
> > The strange thing its that: i controled the processes scheduled by
> > the
at
> > command and the job was correctly scheduled.
> > An other strange thing its that if i schedule a job to run Daily or
Every
> > the director seems work aright.
> >
> > Someone can help me about this?
> >
> > Thanks all.
> >
> > Riccardo Tani
> > Staff Consultant
> > Direzione Industria e Servizi
> > Datamat, Enabling Your Future
> > Rome, Italy
> > e-mail: rtani@datamat.it
> >
>
>
____________________________________________________________________________
_
> http://messenger.yahoo.com.au - Yahoo! Messenger
> - Voice chat, mail alerts, stock quotes and favourite news and lots
> more!
>
Locked