Hello
We have some legacy jobs and no documentation. I am trying to find given a table what jobs are updating the table.
Thanks
Rajesh
Hi @rajesh.wagle
If you're looking at only doing this once, you should be able to use the search function to look for the table name. This should bring up a list of all the jobs that reference that table. You will have to manually review all the components that reference that table including the Table Inputs though.
Let us know if that helps at all!
Many thanks,
Claire
if i search in the search box it is searching in the job name or project name not looking at the underlying target table that may have the table name.
is there a way to look at the target table for the jobs and see what tables are getting updated.
also i need to check about 30 tables so any automated way or any dictionary view will really help.
Hey @rajesh.wagle
You can do this with help of sql script. The job design should
start->sql script in that sql script write one update statement and do update job name
ex: update table name set jobname='your jobname'
it will help you any clarifications ask me here
