A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
Ravi.K
Participant
Posts: 209 Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore
Post
by Ravi.K » Mon Dec 19, 2011 6:13 am
Hi DSExperts,
Is there any command to "RESET" all the aborted jobs in a project.
Currently we are doing this activity job wise by using below command.
dsjob -run -mode RESET $PRO_NAME $JOB_NAME
Cheers
Ravi K
zulfi123786
Premium Member
Posts: 730 Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore
Post
by zulfi123786 » Mon Dec 19, 2011 6:49 am
Guess not as nothing such documented in designer/developer/advanced developer guides
- Zulfi
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Dec 19, 2011 7:17 am
A single command to reset all jobs? No. You could always write one, but it would need to continue to do it 'job wise' as you noted.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Ravi.K
Participant
Posts: 209 Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore
Post
by Ravi.K » Mon Dec 19, 2011 7:37 am
Ok. Is it possible to list out all aborted jobs?
If i get the list of jobs which are aborted then i could reset list of jobs reading each job from the list and then input to dsjob command. it will put all this stuff in UNIX script rather than doing manual work.
Cheers
Ravi K
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Mon Dec 19, 2011 7:39 am
I posted a script called who got failed few months back.
You can find it out If you search here.
pandeeswaran
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Dec 19, 2011 7:41 am
Pretty common to list out all jobs and then check to see if they are aborted. The dsjob executable can list all projects, or all jobs in a project and check the status of a job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Mon Dec 19, 2011 9:10 am
pandeeswaran
Etler21
Participant
Posts: 52 Joined: Mon Mar 08, 2010 5:51 am
Post
by Etler21 » Sat Dec 24, 2011 7:34 pm
I have a script which is doing the same,its been tested and running well since a year and giving no issue.PM me and i will send u the code.
I will try to put that script here as well.
pandeesh
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
Post
by pandeesh » Sat Dec 24, 2011 8:48 pm
Etler21 wrote: PM me and i will send u the code.
I will try to put that script here as well.
Please post it here so that it will be useful for many.
pandeeswaran