Hi Experts !
We work in an environment which is owned by another company and hence, do not have admin access to the application. As a result, we have to ask them to migrate our jobs and sequences from one environment to another (Example: From Test to Production server).
What is the best way of ensuring that they have done this correctly ? Is there a last modified date associated with every job ? If yes, then where do we look for it ?
If not, then is there any efficient way of testing whether all code components were migrated correctly ?
Last Modified Date of a Parallel Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
Last Modified Date of a Parallel Job
Arpit Chopra
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
If your jobs are migrated from IIS Manager then you can easily find out the last package they have created and you can also idetify the which jobs are changed.
If your jobs are migrated from IIS Manager then you can easily find out the last package they have created and you can also idetify the which jobs are changed.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi Arpit,
Since you dont have admin access,you can add last modified date in the comment and then migrate your jobs from dev to prod.I think this is the easiest way.
Since you dont have admin access,you can add last modified date in the comment and then migrate your jobs from dev to prod.I think this is the easiest way.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago
Can you connect to the production environment either with DS-Designer or with Information Server Manager?
In both Tools You can search for changed items within a specified time frame. In Designer use the Advanced-Find dialogue, in ISM the Search Metadata Repository dialogue.
In both Tools You can search for changed items within a specified time frame. In Designer use the Advanced-Find dialogue, in ISM the Search Metadata Repository dialogue.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
I believe you would export your compiled objects into your DSX right?
You would want to ensure that the third party company didn't mess with your code (support reasons may arise), so you would want a combination of compile time and last modified time. The act of loading a DSX into an environment changes the last modified time, but not compile time.
*drops 2 cents into cup*
You should create a basic routine that dumps all jobs all compile and modified times to a text file and ask them to send you that file on an as needed basis.
You would want to ensure that the third party company didn't mess with your code (support reasons may arise), so you would want a combination of compile time and last modified time. The act of loading a DSX into an environment changes the last modified time, but not compile time.
*drops 2 cents into cup*
You should create a basic routine that dumps all jobs all compile and modified times to a text file and ask them to send you that file on an as needed basis.