How to skip already existed JOB in Database?

General Discussion
1

When the script executes, this below error shows:

Reason: liquibase.exception.DatabaseException: ORA-27477: “SBBD_SIT.TEMPGLBALASONHIST_JOB” already exists

so, How to skip the execution if the job is already exists?

.xml file:

 <?xml version="1.0" encoding="UTF-8"?>
 <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                       http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.15.xsd">
 	
 	<changeSet author="xxxx" id="17_proc" runOnChange="true">
    		<sqlFile dbms="oracle"
 	               endDelimiter="/"
 	               path="./TEMPGLBALASONHIST_JOB.sql"
	               relativeToChangelogFile="true"
	               splitStatements="true"
               stripComments="false"/>
   	</changeSet>  

</databaseChangeLog>
2

You can use a precondition and mark the changeset as ran if the job already exists. The precondition can select from oracle’s data dictionary tables to check if the job exists, for example something like this:

select count(*) from all_scheduler_jobs j where j.job_name = 'x' and j.owner = 'y';