You are here:

Create an Inventory Job Definition - Database

Cataloging objects located on a provider is required for browsing, searching, and reporting in ECX.

A Database Inventory job provides the framework to catalog and collect information about your application database servers.

Run a Database Inventory job to analyze your application servers in real time and navigate and correlate the objects from across the Enterprise in a single view. Additionally, you can infer sprawl, storage overutilization, and other storage inefficiencies.

Note: To successfully catalog virtual providers, you must also register associated vCenter providers.

BEFORE YOU BEGIN:

At least one application provider must be associated with a Database Inventory job definition, such as an Oracle resource. Before defining an Inventory job, add application providers. See Register a Provider.
Credentials are required for cataloging application servers. See Identities Overview.
Review Oracle and SQL requirements. See Oracle Requirements, Microsoft SQL Server Requirements, SAP HANA Requirements, InterSystems Caché Requirements.
For email notifications, at least one SMTP server must be configured. Before defining a job, add SMTP resources. See Register a Provider.

CONSIDERATIONS:

If an Oracle Inventory job runs at the same time or short period after an Oracle Backup job runs, copy errors may occur due to temporary mounts that are created during the Backup job. As a best practice, schedule Oracle Inventory jobs so that they do not overlap with Oracle Backup jobs.
One or more schedules might also be associated with a job. Job sessions run based on the triggers defined in the schedule. See Create a Schedule.

To create a Database Inventory job definition:

Click the Jobs tab. Expand the Database folder, then select an application database type to catalog. Available application database types include InterSystems Caché , Oracle, SAP HANA, and Microsoft SQL.
Click New , then select Inventory. The job editor opens.
Enter a name for your job definition and a meaningful description.
From the list of available sites, select one or more providers containing application data that you wish to catalog.
To create the job definition using default options, click Create Job. The job can be run manually from the Jobs tab.
To edit options before creating the job definition, click Advanced. Set the job definition options.
Maximum concurrent tasks
Set the maximum number of concurrent cataloging tasks that can be performed on the provider.
Number of catalog instances to keep
After a certain number of job runs for a given job, older objects for that job are purged from the Inventory. Enter the number of job runs for which high-level objects are to be retained.
Optionally, expand the Notification section to select the job notification options.
SMTP Server
From the list of available SMTP resources, select the SMTP Server to use for job status email notifications. If an SMTP server is not selected, an email is not sent.
Email Address
Enter the email addresses of the status email notifications recipients. Click Add to add it to the list.
Optionally, expand the Schedule section to select the job scheduling options. Select Start job now to create a job definition that starts the job immediately. Select Schedule job to start at later time to view the list of available schedules. Optionally select one or more schedules for the job. As each schedule is selected, the schedule's name and description displays.
Note: To create and select a new schedule, click the Configure tab, then select Schedules . Create a schedule, return to the job editor, refresh the Available Schedules pane, and select the new schedule.
When you are satisfied that the job-specific information is correct, click Create Job. The job runs as defined by your schedule, or can be run manually from the Jobs tab.

Note: If you selected the Start job now option, the job runs.

NEXT STEPS:

If you do not want to wait until the next scheduled job run, run the job session on demand. See Start, Pause, and Hold a Job Session.
Track the progress of the job session on the Jobs tab. See Monitor a Job Session.
If notification options are enabled, an email message with information about the status of each task is sent when the job completes.