Creating copy of a job

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 8:10 am

Hi all,

Is it possible to create a copy of an existing job using Universe commands. I mean by using Universe SQL Commands. (Using insert sql statement).

Thanks,
bhasan.

chulett · Post by **chulett** » Tue Dec 08, 2009 8:31 am

No. Use the GUI.

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 8:37 am

hi Chulett,

May i know the reason. one more doubt am able to rename the jobs, move the jobs from one folder to another in Datastage 7.5. but am unable to do the same in Datastage 8.1. Are there any changes in the properties in the table DS_JOBS in 8.1 version.

Thanks,
bhasan.

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 8:39 am

Adding to the previous post.
-- I cannot rename and move the jobs using Universe SQL commands in 8.1 version.

chulett · Post by **chulett** » Tue Dec 08, 2009 8:42 am

You shouldn't really be doing this in any version, even if you think you know what you are doing. And yes, the architecture in 8.x is vastly different and that information is now stored in two places, things are not just in the 'Universe' repository anymore.

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 9:03 am

Thanks for your prompt reply chulett. May i know those two places where the details of the objects are stored?

chulett · Post by **chulett** » Tue Dec 08, 2009 9:25 am

In the original repository plus the new XMETA database repository.

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 9:34 am

Thanks again. How can we access that XMETA database repository? is it not in Universe database? I am interested to know the details. Please provide me the related links, where can i find those info.

Thanks,
Bhasan.

chulett · Post by **chulett** » Tue Dec 08, 2009 9:38 am

Talk to whomever set up 8.x for you, they had to choose DB2, Oracle or SQL Server for the XMETA repository. And a search here for XMETA should turn up a plethora of topics.

bhasannew · Post by **bhasannew** » Tue Dec 08, 2009 9:42 am

hi chulett,

Thanks for your patience in replying to all my questions.

Thanks,
Bhasan.