Scheduling is not functioning using Datastsage Director

ramu1 · Post by **ramu1** » Fri Jan 15, 2010 8:22 am

Hi ,

I scheduled my Sequence job to run every day at 10.30 PM, previously the sequence Job was run daily based on scheduled time.

But yesterday it has aborted because some database issue, then i compiled the Jobs which were aborted and Compiled the whole sequence.

After that the sequence job is not Running ,from yesterday on wards still it is in compiled status only.

Could you please suggest me what might be the issue?.

Thanks,
Ramu

chulett · Post by **chulett** » Fri Jan 15, 2010 8:55 am

First thing I'd try is to Unschedule the job and then Add it back to the scheduler. Kind of like a reboot.

ramu1 · Post by **ramu1** » Fri Jan 15, 2010 9:13 am

Thanks You Chulett ,

I will Unschedule the job now and add back to the Scheduler.
I will let you know the status by tomorrow.

Thanks,
Ramu

ramu1 · Post by **ramu1** » Sun Jan 17, 2010 1:17 am

Hi Chulett,

I unscheduled the Job and Add the job to schedule ,but the Job is not Running,still it is shows the status as Comiled. When i run the job manually it is Running properly.

Could anybody help in this,what might be the reason.

Thanks,
Ramu

ArndW · Post by **ArndW** » Sun Jan 17, 2010 3:03 am

Can you check the crontab contents with "crontab -l" when logged into UNIX as the same userid and post that information?

ramu1 · Post by **ramu1** » Tue Jan 19, 2010 7:31 am

Hi Arndw,

I checked the cron tab contents and below is the information which i get .

22 22 * * 1,2,3,4,5,6,0 /apps/Assential/Datastage/Projects/ProjectName/dsr_sched.sh /apps/Assential/Datastage/Projects/ProjectName /apps/Assential/Datastage/DSEngine JOB_NAME 0/50/1/0/0 3 >/dev/null 2>&1 #DSJobDS DSJ.ProjectName.3.3

Could you please analyze ,what might be the issue?

Thanks,
Ramu

chulett · Post by **chulett** » Tue Jan 19, 2010 9:08 am

The only one that can analyze this, other than yourself of course, would be a SysAdmin for that box.