Reset aborted jobs across project

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Reset aborted jobs across project

Post by Ravi.K »

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
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

Post by zulfi123786 »

Guess not as nothing such documented in designer/developer/advanced developer guides
- Zulfi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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 »

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
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

I posted a script called who got failed few months back.
You can find it out If you search here.
pandeeswaran
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

check out this:

viewtopic.php?t=141564
pandeeswaran
Etler21
Participant
Posts: 52
Joined: Mon Mar 08, 2010 5:51 am

Post by Etler21 »

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
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

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
Post Reply