Running a job from a different project...

rodre · Post by **rodre** » Tue May 02, 2006 1:13 pm

Can you run a job of another project?

I want to refresh a hash file job from another project, can this be done from datastage?

Thanks,
Rodre

kcbland · Post by **kcbland** » Tue May 02, 2006 1:20 pm

Sure, dsjob takes as parameters the server, userid, password, project, and jobname. The Sequencer and Batch job control API's only work with the current project.

Awhile back I considered writing a universal job control that included the project name with the job, but the functionality of dsjob is not as robust as the API library so I shelved the idea.

So, to run a job in another project, use dsjob to run it, but be aware that you might be limited in your functionality thru dsjob. But you'll probably be fine if you stay to the basics (check job status, optionally reset, run, check job status.)

rodre · Post by **rodre** » Tue May 02, 2006 1:26 pm

Where/How do you use dsjob to run it....
Thanks,
Rodre

kduke · Post by **kduke** » Tue May 02, 2006 1:43 pm

You can refresh a hashed file in another project without running a job in that project. The hashed file has a path or account option below the name. Use the project name for the account and you can update the hash file directly. You could also use the full path to the hashed file.

rodre · Post by **rodre** » Tue May 02, 2006 1:49 pm

I figure out you use the ExecCommand. There might be other ways as well. But, how do you pass the parameters in the command line....?

Here is my command line:
dsjob -user -password -run -mode RESET -wait fazr LeadsNightly_Hash

How do you pass the parameters, which a Enviroment Variable Parameters in the Parameters line:
#$dspwd##$dsuserid#

Rodre

DSguru2B · Post by **DSguru2B** » Tue May 02, 2006 1:53 pm

Try this link: viewtopic.php?t=100109&highlight=dsjob

rodre · Post by **rodre** » Tue May 02, 2006 1:54 pm

You can refresh a hashed file in another project without running a job in that project. The hashed file has a path or account option below the name. Use the project name for the account and you can update the hash file directly. You could also use the full path to the hashed file.

_________________
Mr. Kim Duke

Kim,
This would be a better way to do this. Can you explain a little further as far as how to refresh the hashfile. Do you do it from a sequencer?
Thanks,
Rodre

kduke · Post by **kduke** » Tue May 02, 2006 3:20 pm

It is simple. When you type in the hashed file name in the stage. Below it asks for a path or an account name. Choose Account Name and put in the project name.

If you use a path in both projects then it is even easier. The job can be exported from one project and imported into the other project.

jreddy · Post by **jreddy** » Thu May 04, 2006 2:38 pm

I figure out you use the ExecCommand. There might be other ways as well. But, how do you pass the parameters in the command line....?

Here is my command line:
dsjob -user -password -run -mode RESET -wait fazr LeadsNightly_Hash

How do you pass the parameters, which a Enviroment Variable Parameters in the Parameters line:
#$dspwd##$dsuserid#

Rodre

Use the routine activity to call a command with parameters..