Run Schema job from API

[Amar_Simha]

Hi Team,

I am looking to run a schema job created in Saviynt using Saviynt REST APIs (run job trigger). 

Saviynt Enterprise Identity Cloud API Reference v23.4 (getpostman.com)

However, I am getting the "412 pre-condition failed" error with "trigger not found message".

Please share your views on resolution.

[rushikeshvartak]

Share your job config from control panel

[Amar_Simha]

@rushikeshvartak : Please find below.

[SumathiSomala]

@Amar_Simha Try below payload

{
"triggername": "fileUpload",
"jobname": "SchemaAccountJob",
"jobgroup": "Schema"
}

Check data in Data analyzer.

Sample query:

select triggername,jobname, jobgroup,jobid from ecmimportjob where triggername like 'fileUpload'

If this reply answered your question, please accept it as a solution and kudos.

[rushikeshvartak]

{
    "triggername":"fileUpload",
    "triggergroup":"GRAILS_JOBS",
    "jobname": "SchemaAccountJob",
    "jobgroup": "Schema"
    
    }

[Amar_Simha]

@SumathiSomala : Thank you for your inputs, able to trigger job now.

Also, just for reference, can you please let me know if there is a table in Saviynt which we can refer to get the triggername,jobname, jobgroup for other types of jobs as well. I guess, ecmimport job will have only jobs which are executed and not new ones.

[SumathiSomala]

@Amar_Simha 

ECM Import Job Table (ecmimportjob): This table contains details about imported accounts or access (entitlements).
qrtz_triggers Table: This table stores information about the configured triggers.

qrtz_job_details Table: This table stores detailed information for every configured job.

qrtz_fired_triggers Table:  This table stores the status information about the triggers that have been issued and the relevant execution information about the corresponding job.

Refer below for more details.

Database Schema Reference (saviyntcloud.com)

If this reply answered your question, please accept it as a solution and kudos.

[Amar_Simha]

Thank you @rushikeshvartak @SumathiSomala  for your inputs.

Also, apart from ecmimportjob, I could not find any other table in the list of data analyzer.

[SumathiSomala]

@Amar_Simha Those tables will not visible in data analyzer

You have to generate the report using analytics query.

Just go through the OOTB analytics

example:

[rushikeshvartak]

You can use analytics to view additional tables & use OOTB tables.

[Manu269]

@Amar_Simha you need to run the queries via analtyics to get those details.

I believe there are few OOTB Analytics for the same.

[Amar_Simha]

Thank you @SumathiSomala @Manu269  for the details. Appreciate it.

[Amar_Simha]

@rushikeshvartak @SumathiSomala @Manu269 : I had one more query related to this. Latest 23.10 version of Saviynt supports filtering of SAV files to be processed from the jobs panel. Just wanted to check if we can pass those SAV file names as parameters from runjobtrigger API call?

Also, do we have 23.10 API documentation. latest I can find is of 23.8

Please share your views

[rushikeshvartak]

API Documentation Master Link - https://docs.saviyntcloud.com/category/Dev-Ref

v23.10 API Link - https://documenter.getpostman.com/view/20052500/2s9YJeygdd

You can pass .sav file name in API check parameter name in browser console

[Amar_Simha]

@rushikeshvartak  I have a job with the specific SAV file selected and I am running it from the UI to capture the parameter name. But. I am not able to find any related parameter.

Could you please help me on the same.

[rushikeshvartak]

When you create new job can you check parameter name , i dont have latest version so unable to test