Defining Scheduler Job using Job Wizard

The Job wizard allows you to create a job schedule, using which you can define a workflow job

To define job schedules:

1. In the SQL Developer Connections tab, expand the connection in which your user account is created.

2. Expand Scheduler under that connection.

3. Under Scheduler, right-click Jobs and click New Job (Wizard). The Create Job dialog box opens.

4. In the Create Job Wizard - Step 1 of 6 dialog box, define the Job Details with the following information:

   1. Job Name:

   2. Select Enabled.

   3. Description:

   4. Job Class:

   5. Type of Job: Select Script.

   6. Script Type: Select SQLPlus.

   7. When to Execute Job: Select Repeat Interval.

   8. In the Repeat Interval dialog box, set the repeat interval, start date, time and click OK.

   9. Click Next.

5. In the Create Job Wizard - Step 2 of 6 dialog box, define the following:

   1. Select the option Local from the drop-down list.

   2. Select Credential: Select the host credential that you created in Creating Credentials for Database Host and Database from the drop-down list.

   3. Connect Credential Name: Select the connection credential that you created in Creating Credentials for Database Host and Database from the drop-down list.

   4. Click Next.

6. In the Create Job Wizard - Step 4 of 6 dialog box, you can set up email notification based on the job status.

   1. In the Select Events section, select the job events for which you want to send email notifications.

   2. In the Recipients field, enter the email address. For each message, you can specify recipient email addresses and the sender (optional).

   3. Click Next.

7. In the Create Job Wizard - Step 5 of 6 dialog box, click Next. For this use case, this step is skipped.

8. In the Create Job Wizard - Step 6 of 6 dialog box, click Finish. This completes the creation of the job schedule.

After creating the job, you can monitor it in SQL Developer.