Page 1 of 1

Back up from command line excluding the job executable

Posted: Thu Apr 05, 2007 7:15 am
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.

Posted: Thu Apr 05, 2007 7:50 am
by ray.wurlod
dscmdexport options < .\NUL

.\NUL delivers an infinite supply of "presses of the Enter key".

Posted: Thu Apr 05, 2007 7:52 am
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.

Posted: Thu Apr 05, 2007 9:01 pm
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.

Posted: Thu Apr 05, 2007 9:05 pm
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.

Posted: Thu Apr 05, 2007 9:57 pm
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:

Posted: Fri Apr 06, 2007 6:20 am
by kduke
You are a morning person, right?

You are correct I am a night owl.

Posted: Fri Apr 06, 2007 6:53 am
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: