Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, depending on which department generates the report. The format of the reports is being developed; currently, the format changes daily.
How would you configure the database to ensure that each department generates its report (based on its target data) using the most recent report format every day?
A.
By having each user run the report generation procedure at the scheduled time, supplying the necessary input variables.
B.
By creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB.
C.
By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D.
By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E.
By creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER.
Explanation:
Job Arguments
You can specify job arguments to customize a named program object. Job arguments override the default argument values in the program object, and provide values for those program arguments that have no default value. In addition, job arguments can provide argument values to an inline action (for example, a stored procedure) that the job specifies.
A job cannot be enabled until all required program argument values are defined, either as defaults in a referenced program object, or as job arguments.
A common example of a job is one that runs a set of nightly reports. If different departments require different reports, you can create a program for this task that can be shared among different users from different departments. The program action would be to run a reports script, and the program would have one argument: the department number. Each user can then create a job that points to this program, and can specify the department number as a job argument.
Ref.:
Oracle Database Administrator�s Guide 10g Release 2 (10.2). Page: 26-5.