Back up from command line excluding the job executable

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kaushik
Participant
Posts: 8
Joined: Mon Aug 28, 2006 2:31 am

Back up from command line excluding the job executable

Post by kaushik »

I need to take the back up from command line interface excluding the job executable and at the export time if a job/object is locked then automatically it will skip that job without asking for user intervention.

Currently I am running a scheduled script of dsxport command from my windows XP m/c which is taking the export of the whole project including the executable and if a job is locked then asking for user to skip that job.

I really need your help.
Thanks
Kaushik
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

dscmdexport options < .\NUL

.\NUL delivers an infinite supply of "presses of the Enter key".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The backup script available on Kim Duke's website will automatically skip locked jobs and log the ones skipped. I believe you are out of luck on the 'no executables' part.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

My script has a way to unlock all jobs too. Not wise in the daytime but at 2 in the morning it is safe.
Mamu Kim
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

It runs Dwn_ExecTCL.exe which is a VB program I wrote. It will run any TCL command from the client. So it is programmed in my script to run UNLOCK ALL in the UV account. It writes to a log file. It has a debug mode which writes the output to a GUI screen like DataStage Administor.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

kduke wrote:My script has a way to unlock all jobs too. Not wise in the daytime but at 2 in the morning it is safe.
Safe for most peoples, I'm sure. I'll bet not safe for you, you night owl. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

You are a morning person, right?

You are correct I am a night owl.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I've been known to be both. Back those up one after the other and what do you get? Not alot of sleep. [yawn] :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply