Toad -Schedule Job Create

 

Toad -Schedule Job Create 

Go to Schedule Job:

1.       Basic Info:

Write your Job Name:

2.       Schedule Info:
Click the Mouse Right ButtonàSelect Now

Select the Time schedule for the run.

1. 

      3.      Program Info: 

At first, create a Procedure. Then Call the Procedure.
For Example:

CREATE OR REPLACE PROCEDURE update_retailer_categories

AS

BEGIN

    UPDATE xx_retailer r

       SET column_name= value;

    COMMIT;

END;

/