Can we add "create or replace job, or create or replace scheduler .. " in changeset ?

General Discussion
1

Hello ALL,

My oracle has some procedures, which do some works regularly.

Now we use liquibase to update the database.

I added "create or replace procedure .. " in changeset,  they work well, I can see the created procedures, meanwhile, I could find many examples online,

but I still need to add a job and a scheduler to the database, so the procedures can work according to the definition of scheduler in a  job.

I can not  find a way to add job and scheduler in liquibase, and can not find examples online.

Does anyone have experiences to do this?

many thanks.

R 

2

@RUIJUN Did you get a resolution?

3

I assume you are using dbms_scheduler to create a job. Since you interact with dbms_scheduler via a stored procedure execution, yes you can use Liquibase to create a job. You would use custom sql in either xml, yaml, json, or formatted sql to call the dbms_scheduler stored procedure, like this generic stored procedure execution xml example:

<changeSet id="Execute PL/SQL" author="XYZ">
  <sql endDelimiter="/">
    BEGIN
        Stored_procedure(X,Y,Z);
    END;
    /  
  </sql>
</changeSet>