Error in Scheduling
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Error in Scheduling
Hi All,
I have a problem in schedulng my jobs.
Issue:
1.When i try to schedule a job "test11" in a proj called "BI_1A",it throws me an error
"Error adding to schedule: at: 0481-166 The auditproc function failed with errno 1.(Command was: at -s 11:25 today )
(Data was: /db2tmp1p101/ds/Ascential/DataStage/Projects/BI_1A/dsr_sched.sh /db2tmp1p101/ds/Ascential/DataStage/Projects/BI_1A /software/ds/Ascential/DataStage/DSEngine test11 0/50/1/0/0 1 >/dev/null 2>&1) "
2.I have tried scheduling with a different project in the same server even it throws me a similar error.
3.I have also copied the "dsr_sched.sh" file from a different server where iam able to schedule the jobs to this server and still i get the error.
Has anyone come across this issue?
Help me come out of this issue?
Regards,
I have a problem in schedulng my jobs.
Issue:
1.When i try to schedule a job "test11" in a proj called "BI_1A",it throws me an error
"Error adding to schedule: at: 0481-166 The auditproc function failed with errno 1.(Command was: at -s 11:25 today )
(Data was: /db2tmp1p101/ds/Ascential/DataStage/Projects/BI_1A/dsr_sched.sh /db2tmp1p101/ds/Ascential/DataStage/Projects/BI_1A /software/ds/Ascential/DataStage/DSEngine test11 0/50/1/0/0 1 >/dev/null 2>&1) "
2.I have tried scheduling with a different project in the same server even it throws me a similar error.
3.I have also copied the "dsr_sched.sh" file from a different server where iam able to schedule the jobs to this server and still i get the error.
Has anyone come across this issue?
Help me come out of this issue?
Regards,
Sakthi
Have you ever tried scheduling any jobs via datastage/ outside of datastage?
Try to schedule the same using command prompt in the AT.
Else you may need to check the permission for your user id.
Check .allow and .deny file has the entry of your user id.
Try to schedule the same using command prompt in the AT.
Else you may need to check the permission for your user id.
Check .allow and .deny file has the entry of your user id.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Hi Kumar,
1.I am able to schedule jobs in a different unix server(say server 141) in datastage,but not with this unix server(say server 142) alone.
2.I have not scheduled any jobs outside datastage.
3.I am sure my user id has all permissions,
sorry for my illiteracy where do i find the .allow and .deny file in unix server.
Regards,
1.I am able to schedule jobs in a different unix server(say server 141) in datastage,but not with this unix server(say server 142) alone.
2.I have not scheduled any jobs outside datastage.
3.I am sure my user id has all permissions,
sorry for my illiteracy where do i find the .allow and .deny file in unix server.
Regards,
Sakthi
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Hi All,
I was unable to check that since i didnot have permissions in CRON.
I have spoke to my SA and he has confirmed that my UserId has all the permissions to schedule the job.
He has also compared the settings and permissions of my UserId with another one Userid which is working,they both are the same.
Any other workarounds or soluntions??????
Regards,
I was unable to check that since i didnot have permissions in CRON.
I have spoke to my SA and he has confirmed that my UserId has all the permissions to schedule the job.
He has also compared the settings and permissions of my UserId with another one Userid which is working,they both are the same.
Any other workarounds or soluntions??????
Regards,
Sakthi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Hi All,
Thanks everyone for your inputs.
I worked with my SA and scheduled a script on the same unix server by myself.
I am able to schedule the script with my UserId and it successfully ran at the scheduled time using the CRONTAB command.
But, still Iam unable to do that through Datastage.
Any other inputs?
Regards,
Thanks everyone for your inputs.
I worked with my SA and scheduled a script on the same unix server by myself.
I am able to schedule the script with my UserId and it successfully ran at the scheduled time using the CRONTAB command.
But, still Iam unable to do that through Datastage.
Any other inputs?
Regards,
Sakthi
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Hi Kumar,
I went through the pdf it states that, something got to do with the AT or CRONTAB command.
Can you confirm whether Datastage uses CRONTAB or AT command to schedule the jobs through the Unix Server?
Which is the underlying process to schedule jobs CRONTAB or AT thru unix?
So that I can work with my SA to schedule it.
Regards,
I went through the pdf it states that, something got to do with the AT or CRONTAB command.
Can you confirm whether Datastage uses CRONTAB or AT command to schedule the jobs through the Unix Server?
Which is the underlying process to schedule jobs CRONTAB or AT thru unix?
So that I can work with my SA to schedule it.
Regards,
Sakthi
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai