how to find scheduled jobs and scheduled imports that update the tables below : Users Domains Groups Group members.

nani625
Kilo Contributor

how to find scheduled jobs and scheduled imports that update the tables below :

Users

Domains

Groups

Group members.

and export them

10 REPLIES 10

Hi Naveen,



As harishdasari has mentioned above, you can search that way. Just one input regarding searching Scheduled Imports. You can directly search in the Table Transform Map table by navigating System Import Sets-->Administration-->Transform Maps-->Search with the Target table. Once you get the result, do search in the Data Source table whether those transform maps are being used.



Regarding Scheduled Job, you need to search in the below ways:


1. Type sysauto_script.LIST in your application navigation search bar and set the filter as below with the table name. Like I have searched with the User table name. Once you get the result, check whether the script in updating/inserting anything on the table.


find_real_file.png



2. Also, any server side script may be triggered by System Scheduler-->Scheduled job. Here the script gets called by it's name in the Job Context field. You may take the reference of OOB Scheduled Job named 'Autoclose Incidents' where the Business rule 'incident autoclose' gets called. Now if in the called Script the table(s) get updated/inserted, you need to take count of that Scheduled job too.



I hope this helps. Please mark correct/helpful based on impact


nani625
Kilo Contributor

i didn't get your point can you please explain.


Hi Naveen,



Could you please let me know which part you didn't get? I just guided you to search in a better way


nani625
Kilo Contributor

I need to send the list of all scheduled jobs and scheduled imports that update the tables below :



Users


Domains


Groups


Group members.


How to check and import the above requirement.


Hi Naveen,



That's what I described in my earlier response. There is no such straightforward way to search what you are looking for. For Scheduled Import please follow the response of Harish. And for Scheduled Job, please follow the 2 points. You need to provide some extra effort as I have mentioned already.



I hope this helps. Please mark correct/helpful based on impact