Datastage Scheduler

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

Post by admin »

Im guessing this is on a Windows NT machine. It looks like there is a problem querying the Registry (you only gave us part of the error message - maybe you only got part). Is that all there is in dsr_sched.log?

Is your Registry damaged or running out of space? (Are there any messages in the System event log to this effect? Open Control Panel, System, choose the Performace tab, click Change, then see what the current and maximum Registry sizes are - it might be worth while increasing the Registry size
anyway.)

Is your Schedule service still running at the time the job is scheduled to start?

> ----------
> From: Seema Ranchoddas[SMTP:seemar@netcare.co.za]
> Reply To: informix-datastage@oliver.com
> Sent: Tuesday, 28 November 2000 00:49
> To: informix-datastage@oliver.com
> Subject: DataStage Scheduler
>
> When I try scheduling a job, Datastage prompts me to enter the
> parameters, etc. It then shows that the job is scheduled. However,
> when its time for the job to start running, nothing happens and the
> status of the job remains as it was.
>
> When I view the dsr_sched.log file the following message appears:
> "Error 2 in RegQueryValueEx:
> The system cann"
>
> Does anyone know what causes this error and how it can be corrected.
>
> Seema
>
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

This is a NT Machine (NT 4). The message I gave was all that was in the dsr_sched.log file. Ive checked the size of the registry. Current is 7 MB, maximum is 96 MB. The schedule service is started when the scheduled job is trying to run. If I run the at command within the dos prompt, the scheduled job and time is displayed.

Seema

>Date: Mon, 27 Nov 2000 08:57:27 -0500
>To: "informix-datastage@oliver.com"
>From: Ray Wurlod
>Subject: RE: DataStage Scheduler
>Message-ID:

>
>Im guessing this is on a Windows NT machine. It looks like there is a
>problem querying the Registry (you only gave us part of the error
>message - maybe you only got part). Is that all there is in
>dsr_sched.log?
>
>Is your Registry damaged or running out of space? (Are there any
>messages in the System event log to this effect? Open Control Panel,
>System, choose the Performace tab, click Change, then see what the
>current and maximum Registry sizes are - it might be worth while
>increasing the Registry size
>anyway.)
>
>Is your Schedule service still running at the time the job is scheduled
>to start?
>
>> ----------
>> From: Seema Ranchoddas[SMTP:seemar@netcare.co.za]
>> Reply To: informix-datastage@oliver.com
>> Sent: Tuesday, 28 November 2000 00:49
>> To: informix-datastage@oliver.com
>> Subject: DataStage Scheduler
>>
>> When I try scheduling a job, Datastage prompts me to enter the
parameters,
>> etc. It then shows that the job is scheduled. However, when its time
>> for the job to start running, nothing happens and the status of the
>> job remains as it was.
>>
>> When I view the dsr_sched.log file the following message appears:
>> "Error 2 in RegQueryValueEx:
>> The system cann"
>>
>> Does anyone know what causes this error and how it can be corrected.
>>
>> Seema
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Datastage Scheduler

Post by admin »

I still have a problem with Scheduling Jobs on Datastage. I am using DataStage v3.6 and NT 4, Service Pack 6. When I schedule a job and run the AT command, the scheduled job is displayed. However, the job does not run.

The DataStage support in Johannesburg has told me that the problem is using Datastage 3.6 and Service Pack 6. However, I have tried scheduling a job on another machine (NT4 and Service Pack 4) and the scheduled job does not run.

Can anyone help me please.

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

Post by admin »

Seema,

You should check the follwing things:
- Check to see how the Schedule Service Logs On
- Create a simple CMD file ie
C:/temp/Test.cmd
Echo Test > C:/temp/trace.txt
- At 18:13 C:/temp/test.cmd
- If the above works you may need to have your schedule service log on as a Specific User
and allocate that user the required Privledges.

Jack
----- Original Message -----
From: "Seema Ranchoddas"
To:
Sent: Monday, December 04, 2000 5:53 PM
Subject: Datastage Scheduler


I still have a problem with Scheduling Jobs on Datastage. I am using DataStage v3.6 and NT 4, Service Pack 6. When I schedule a job and run the AT command, the scheduled job is displayed. However, the job does not run.

The DataStage support in Johannesburg has told me that the problem is using Datastage 3.6 and Service Pack 6. However, I have tried scheduling a job on another machine (NT4 and Service Pack 4) and the scheduled job does not run.

Can anyone help me please.

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

Post by admin »

I had already set the Schedule Service to start automatically for a user account(Administrator). I tried the Test.cmd and it works. I have also tried creating another user and setting the schedule service to start automatically for that user account, logged on as that user and tried scheduling the job in Datastage. The job still didnt run.

Any more ideas??

Seema


>
>----- Original Message -----
>From: "Jack Luchjenbroers"
>To:
>Sent: 04 December 2000 10:45
>Subject: Re: Datastage Scheduler
>
>
>> Seema,
>>
>> You should check the follwing things:
>> - Check to see how the Schedule Service Logs On
>> - Create a simple CMD file ie
>> C:/temp/Test.cmd
>> Echo Test > C:/temp/trace.txt
>> - At 18:13 C:/temp/test.cmd
>> - If the above works you may need to have your schedule service log
>> on as
>a
>> Specific User
>> and allocate that user the required Privledges.
>>
>> Jack
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Seema,

Have you tried testing the other way:
- Logging on to DataStage as the user account(Administrator)
- Bearing in mind that the first time login as a New user it is
a good idea to use the DomainName as well as the user Id.
ie DomainName /User Id
(not sure of the direction of the / and my other one doesnt work on this keeboard.
- If your user is local to this machine then the DomainName is proberly your Machine Name.


Thanks Jack
----- Original Message -----
From: "Seema Ranchoddas"
To:
Sent: Monday, December 04, 2000 8:21 PM
Subject: Fw: Datastage Scheduler


> I had already set the Schedule Service to start automatically for a
> user account(Administrator). I tried the Test.cmd and it works. I have
> also
tried
> creating another user and setting the schedule service to start
> automatically for that user account, logged on as that user and tried
> scheduling the job in Datastage. The job still didnt run.
>
> Any more ideas??
>
> Seema
>
>
> >
> >----- Original Message -----
> >From: "Jack Luchjenbroers"
> >To:
> >Sent: 04 December 2000 10:45
> >Subject: Re: Datastage Scheduler
> >
> >
> >> Seema,
> >>
> >> You should check the follwing things:
> >> - Check to see how the Schedule Service Logs On
> >> - Create a simple CMD file ie
> >> C:/temp/Test.cmd
> >> Echo Test > C:/temp/trace.txt
> >> - At 18:13 C:/temp/test.cmd
> >> - If the above works you may need to have your schedule service log
> >> on
as
> >a
> >> Specific User
> >> and allocate that user the required Privledges.
> >>
> >> Jack
>
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Jack ,
I tried logging onto datastage as the user account as well as locally and the result is the same. The scheduled job does not run.

Am I correct in saying that once NT Scheduling service is started, the username and password must be entered in Datastage Administrator, then a job can be scheduled in Director and it should run. Am I supposed to do anything else?

Thanx.

Seema

>----- Original Message -----
>From: "Jack Luchjenbroers"
>To:
>Sent: 04 December 2000 01:16
>Subject: Re: Datastage Scheduler
>
>
>> Seema,
>>
>> Have you tried testing the other way:
>> - Logging on to DataStage as the user account(Administrator)
>> - Bearing in mind that the first time login as a New user it is
>> a good idea to use the DomainName as well as the user Id.
>> ie DomainName /User Id
>> (not sure of the direction of the / and my other one doesnt work
>> on this keeboard.
>> - If your user is local to this machine then the DomainName is
>> proberly
>your
>> Machine Name.
>>
>>
>> Thanks Jack
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Seema,

When you connect to a DataStage Server from your Client PC you connect as a particular User then as far as the server is concered you have those rights & privledges that have been assigned to that user (Either by the OS or by Datastage/Universe).

When you schedule a Datastage Job then when it starts it connects as a User. Then if it has insufficient Rights the job would proberly fail to start.

There is anther area that you could check and that is in Project Administration => Properties => Schedule.

I have not used this setting but I surgest that you use the Test & Help Buttons.

One other thing that may be note worthy I remember that when changing the attributes of the Schedule Service on NT3.51 It would not perform as expected until I bounced the Box (Shutdown & Restart), this may have been rectified by stopping and re-starting the service but if you have the machine to yourself I would bounce it.

In your position I would:
- set the schedule service back to Local System Account
- Bounce the Box
- Use Project Administration => Properties => Schedule.
In the First Instance
- Use your Own Credentials
- Try the test Button (Asscert Success)
- Schedule A job.
Now that this works :-)
- Use your Preferred Credentials
- Try the test Button (Asscert Success)
- Schedule A job.

Please let me know how you go.


Jack.

----- Original Message -----
From: "Seema Ranchoddas"
To:
Sent: Monday, December 04, 2000 10:01 PM
Subject: Fw: Datastage Scheduler


> Jack ,
> I tried logging onto datastage as the user account as well as locally
> and the result is the same. The scheduled job does not run.
>
> Am I correct in saying that once NT Scheduling service is started, the
> username and password must be entered in Datastage Administrator, then
> a
job
> can be scheduled in Director and it should run. Am I supposed to do
anything
> else?
>
> Thanx.
>
> Seema
>
> >----- Original Message -----
> >From: "Jack Luchjenbroers"
> >To:
> >Sent: 04 December 2000 01:16
> >Subject: Re: Datastage Scheduler
> >
> >
> >> Seema,
> >>
> >> Have you tried testing the other way:
> >> - Logging on to DataStage as the user account(Administrator)
> >> - Bearing in mind that the first time login as a New user it is
> >> a good idea to use the DomainName as well as the user Id.
> >> ie DomainName /User Id
> >> (not sure of the direction of the / and my other one doesnt
> >> work
on
> >> this keeboard.
> >> - If your user is local to this machine then the DomainName is
> >> proberly
> >your
> >> Machine Name.
> >>
> >>
> >> Thanks Jack
>
>
>
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

Jack,
Ive omitted the username and password from the Schedule tab in Administrator. Reason being that I am connecting to Datastage using Administrator and it has all privileges.

Ive tried everything youve said. It still doesnt work with my username or Administrator.

I cant think of anything else. If you do think of anything, please let me know. Thanx for you help.

Seema

>Date: Tue, 5 Dec 2000 17:53:08 +0930
>To:
>From: "Jack Luchjenbroers"
>Subject: Re: Datastage Scheduler
>Message-ID:
>
>Seema,
>
>When you connect to a DataStage Server from your Client PC you connect
>as a particular User then as far as the server is concered you have
>those rights & privledges that have been assigned to that user (Either
>by the OS or by Datastage/Universe).
>
>When you schedule a Datastage Job then when it starts it connects as a
User.
>Then if it has insufficient Rights the job would proberly fail to
>start.
>
>There is anther area that you could check and that is in Project
>Administration => Properties => Schedule.
>
>I have not used this setting but I surgest that you use the Test & Help
>Buttons.
>
>One other thing that may be note worthy I remember that when changing
>the attributes of the Schedule Service on NT3.51 It would not perform
>as expected until I bounced the Box (Shutdown & Restart), this may have
>been rectified by stopping and re-starting the service but if you have
>the machine to yourself I would bounce it.
>
>In your position I would:
>- set the schedule service back to Local System Account
>- Bounce the Box
>- Use Project Administration => Properties => Schedule.
> In the First Instance
> - Use your Own Credentials
> - Try the test Button (Asscert Success)
> - Schedule A job.
> Now that this works :-)
> - Use your Preferred Credentials
> - Try the test Button (Asscert Success)
> - Schedule A job.
>
>Please let me know how you go.
>
>Jack.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Post by admin »

The username and password in administrator does not do anything except allow you to test that it works. It is not otherwise used (as far as I know) on Windows NT.

I suggest that you go to the "schedule" service under services in control panel and check which user it is running as. As best I can tell, all scheduled actions (ie AT) under Windows NT run under the same user, the one indicated here.

You might even try changing this user. We have.

Hope this helps.

-----Original Message-----
From: Seema Ranchoddas [SMTP:seemar@netcare.co.za]
Sent: Wednesday, 6 December 2000 18:41
To: informix-datastage@oliver.com
Subject: Re: Datastage Scheduler

Jack,
Ive omitted the username and password from the Schedule tab in
Administrator. Reason being that I am connecting to Datastage using
Administrator and it has all privileges.

Ive tried everything youve said. It still doesnt work with my username or
Administrator.

I cant think of anything else. If you do think of anything, please let me
know.
Thanx for you help.

Seema

>Date: Tue, 5 Dec 2000 17:53:08 +0930
>To:
>From: "Jack Luchjenbroers"
>Subject: Re: Datastage Scheduler
>Message-ID:
>
>Seema,
>
>When you connect to a DataStage Server from your Client PC you connect as a
>particular User then as far as the server is concered you have those rights
>& privledges that have been assigned to that user (Either by the OS or by
>Datastage/Universe).
>
>When you schedule a Datastage Job then when it starts it connects as a
User.
>Then if it has insufficient Rights the job would proberly fail to start.
>
>There is anther area that you could check and that is in Project
>Administration => Properties => Schedule.
>
>I have not used this setting but I surgest that you use the Test & Help
>Buttons.
>
>One other thing that may be note worthy I remember that when changing the
>attributes of the Schedule Service on NT3.51 It would not perform as
>expected until I bounced the Box (Shutdown & Restart), this may have been
>rectified by stopping and re-starting the service but if you have the
>machine to yourself I would bounce it.
>
>In your position I would:
>- set the schedule service back to Local System Account
>- Bounce the Box
>- Use Project Administration => Properties => Schedule.
> In the First Instance
> - Use your Own Credentials
> - Try the test Button (Asscert Success)
> - Schedule A job.
> Now that this works :-)
> - Use your Preferred Credentials
> - Try the test Button (Asscert Success)
> - Schedule A job.
>
>Please let me know how you go.
>
>Jack.




*************************************************************************
This e-mail and any files transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in
error, please notify the sender by return e-mail, and delete this e-mail from your in-box. Do not copy it to anybody else

*************************************************************************
Locked