ā08-28-2012 08:53 AM - edited ā03-01-2019 08:55 AM
i was attempting to locate a job by opening hundreds of jobs one at time that is using a particular FTP host and/or FTP user. i found some but i know there might be others that i might have missed. i know that this can be done thru query however because i do not have access to the tidal database i can't see what tables or views that i could use to do the query. please help what are the tables/views and column that i should use to built the query.
thank you,
warren
ā08-30-2012 01:10 PM
similar to the job search string... it is just slightly modified
jobdtl_params will contain the FTP Host information that would be pretty straigh forward
jobdtl_params like '%
However the FTP or Runtime users are trickier
you need job_proxy and job_proxy2 from jobdtl table to get the FTP User
in the case of FTP jobs you need to go after job_proxy2 for the FTP User
(NOTE: if you have the data model help file from tidal it says it's the runtime user but it doesn't seem that that is true for FTP jobs its the FTP user)
if you have a user ID you know you are looking for you can get add the ID and use that in your criteria
Where
jobdtl_proxy2 = ###
you can search the usrmst table for the ID's you want
select
usrmst_id,usrmst_name from usrmst
where
usrmst_name like
if you use inheritance for FTP user it gets far trickier
'%< FTP user or part of FTP user you want>%'
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide