Sometimes a job loses it's design information. I am really not sure how this happens but it does. Is there a(ny) way to identify jobs that don't have design information?
One way that comes to my mind is to compile the jobs and look at the error message to find such odd ones. But this is time consuming when we want to check the odd ones among 2000+.
Any way to identify jobs that don't have design information?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Any way to identify jobs that don't have design information?
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
No luck Kim.
Initially, i was happy with your clue and tried queries against DS_JOBS and DS_JOBOBJECTS. After analysis, realized that some of the other jobs that have design information are not having ROOT record in DS_JOBOBJECTS.
I am still trying.. Do let me know if you get any idea.. Thank you.
Initially, i was happy with your clue and tried queries against DS_JOBS and DS_JOBOBJECTS. After analysis, realized that some of the other jobs that have design information are not having ROOT record in DS_JOBOBJECTS.
I am still trying.. Do let me know if you get any idea.. Thank you.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: