How to check whether sync job is running or not

[surajbarnwal]

How can we check in our GRC system, whether the Action sync job for a particular connector is running or not.? And if it is running, what is the frequency, and who had scheduled it?

Please assist!

[Mate · Accepted solution]

Dear Suraj,

there are some ways, however the best is to check SM37 and filter for GRAC_ACTION_USAGE_SYNC ABAP Program Name. You will see the list of jobs which was scheduled. You can immediately see the user who created the job. By double clicking on the particular job, you will see the frequency, and you can check the Steps. In the Steps you will see the actual UserID which will run the job, and then by opening the Goto menu and clicking the Variant you will see the actual Variant where you can see what parameters (like connector list) is used to run the job.

Best regards, Mate

[surajbarnwal · Accepted solution]

Thanks Mate, for your prompt reply!

Can I have some other way apart from checking the job logs in SM37?

I have multiple backend systems linked with GRC, and it is very difficult to check each and every job to get the required connector-related job. Also, there are multiple Action sync jobs running frequently in the system. But recently I have realized that, for some connectors, it is not running(and also not able to find the same via sm37).

[Mate · Accepted solution]

You can query table GRACTASKEXECSTMP for TASK_NAME "ACTION_USAGE_SYNC" to find when was the last successful execution of Action Usage Synch for a particular connector. This will only give a hint whether the job is running or not, however you will not be able to see the frequency, scheduled user and the rest of the job related information. I suggest to create named variants for the connectors and name the background jobs with connector names as well. In this case you can easily identify them. Also the suggested frequency is to run the job hourly. Also one more important information, do not fill the USER_ID field, it should be completely empty.