nerdexam
Oracle

1Z0-062 · Question #377

What should you do for a Scheduler to start a job when a file arrives on a remote system?

The correct answer is A. Start an Oracle database instance on the remote system and register the Scheduler agent with. To enable Oracle Scheduler to trigger a job based on a file arriving on a remote system, an Oracle Scheduler agent must be deployed on that remote system and registered with the database that defines the job.

Performing Database Maintenance

Question

What should you do for a Scheduler to start a job when a file arrives on a remote system?

Options

  • AStart an Oracle database instance on the remote system and register the Scheduler agent with
  • BInstall the Scheduler agent on the remote system and register the agent with the database on the
  • CEnsure dedicated server is enabled on both the local and remote databases.
  • DShutdown the file watcher on the local system.

How the community answered

(51 responses)
  • A
    82% (42)
  • B
    12% (6)
  • C
    2% (1)
  • D
    4% (2)

Why each option

To enable Oracle Scheduler to trigger a job based on a file arriving on a remote system, an Oracle Scheduler agent must be deployed on that remote system and registered with the database that defines the job.

AStart an Oracle database instance on the remote system and register the Scheduler agent withCorrect

Oracle Scheduler's file watcher functionality for remote systems requires an external Scheduler agent to be deployed on that remote system. This agent monitors the specified file and communicates its status back to the database where the job is defined, often requiring an Oracle environment (such as a database instance or client installation) on the remote machine for agent deployment and registration.

BInstall the Scheduler agent on the remote system and register the agent with the database on the

This option is incomplete, lacking specification of what to register the agent with, and assumes installing 'just' the agent might be sufficient without considering underlying Oracle environment requirements for agent deployment.

CEnsure dedicated server is enabled on both the local and remote databases.

Dedicated server mode affects how client connections are handled by the database, but it does not directly enable or facilitate a Scheduler agent's ability to monitor remote files.

DShutdown the file watcher on the local system.

Shutting down the file watcher on the local system would prevent any file monitoring, directly contradicting the goal of starting a job when a file arrives.

Concept tested: Oracle Scheduler Remote File Watching Configuration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/admin/managing-oracle-scheduler.html#GUID-98B29124-B1F3-43C3-8903-88220B8CC671

Topics

#Oracle Scheduler#job scheduling#remote systems#Scheduler agent

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice