Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

After you run a job, you can see its default report, and you can export a report in various formats.

To view or print a default job report

  • On the Results tab, click the View Report button.
    The report opens in a separate window and can be read on screen, sent to a printer, and saved to disk.

To save a report in a particular file format

  1. On the Results tab, click the Export Results button.
  2. In the Export dialog, select a directory location where the report will be saved.
    Image Removed
  3. Click an output format.
  4. Click Report Preferences.
  5. In the Report Preferences tabs, select the visual properties of the report including style, paper size, and font. For details about the preferences, see Reports.
  6. In the Contents tab, specify the criteria to include in the report.
    • For configuration comparison jobs:
      • Select Include matching configuration parameters to include configuration parameters and values that matched when the job was run.
    • For data comparison jobs:
      • Select Include matching data fields (database level) to include tables and/or views that matched in a data comparison job. If this option is not checked, only comparison tables and/or views that did not match will be included.
      • Select Include matching data fields (table level), after deselecting the database level option, to include data fields that matched in rows, for which one value did not match. If this option is not checked, only comparison key values and values that did not match are included.
      • Select Include detail reports in CM/Data notifiers to include information for all data fields selected in a data comparison job.
    • For schema comparison jobs:
      • Select Include matching schema objects to include information about the objects that matched in a schema comparison job.
      • Select Include DDL in Schema Reports to include information about the DDL.

        Info

        A schema report runs faster if you do not generate the DDL in the report.

      • Use the Split reports when exceeding number of objects option to limit the number of objects per section.

        Info

        If your schema comparison reports are very large and use a lot of memory, you can split them into smaller sections for better performance.

Scheduling a Job

You can use Windows Task Scheduler to run jobs on a regular schedule.

To schedule a job

  1. In a job editor, click the Schedule Job button.
    Image Added

    Info

...

  1. You can also open the Job Scheduler from the Tools > Schedule Job menu or right-click on any job, and then select Schedule Job.

  2. In the informational dialog, click OK.
  3. In the Schedule tab, specify when and how often you want the job to run, and then click OK.

...

  1. Image Added
  2. In the dialog, verify your user name and type your Windows password

...

  1. , and then click OK. 
    The Job Scheduler gives you additional options on the Settings tab.
    Image Added

To modify an existing job schedule

  1. In the toolbar, click the Open Scheduled Tasks button.
    Image Added
  2. In the Scheduled Tasks list, double-click the job you want to change.


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse