Execution environment
This command can be run on an operation management client.
Privileges required for execution
The privileges of a user belonging to the "Administrators" group are required to execute this command.
Note
To execute this command under Windows Vista(R)/Windows(R) 7/Windows(R) 2008 environment, execute with the administrator privilege. Select [Start] button of Windows, [All Programs], [Accessories], [Command prompt], and select [Run as administrator] of the right click menu, and then execute this command.
To execute this command by registering it with Task Scheduler for the Windows Vista(R)/Windows(R) 7/Windows(R) 2008 environment, select the General tab of the Properties window for the task to be registered, and then select the Run with highest privileges checkbox.
Function
This command creates a scheduled report that has been registered using the Scheduled Report View. If this command is registered with a scheduler, the operation can be performed automatically.
Created reports can be viewed in the Scheduled Report View.
Syntax
<Installation directory>\bin\sqcMakeReport | -c console_define [-g system_group] [-t begin_time | -w begin_day | -d begin_date] daily|weekly|monthly |
<Installation directory>\bin\sqcMakeReport | -c console_define [-g system_group] [-s start_day -e end_day] daily|weekly|monthly |
Operand
Specifies the report format (daily, weekly or monthly).
Options
Specifies the console definition name for the report to be created. This parameter cannot be omitted.
Specifies the system group name. Only registered scheduled reports whose conditions include the specified system group will be created. If this option is omitted, all scheduled reports that have been registered will be created.
Point
By registering the command with a scheduler with this option specified, report scheduling can be performed in system group units.
Specifies the time (0 to 23) local time that a daily report will start. A daily report will be created from 24 hours of data that commences at the specified time. If this option is omitted, the starting time defaults to "0".
Specifies the day of the week (Su, Mo, Tu, We, Th, Fr, Sa) that a weekly report will start. A weekly report will be created from 7 days of data that commences on the specified day of the week. If this option is omitted, the starting day defaults to Sunday ("Su").
Specifies the date (1 to 28) that a monthly report will start. A monthly report will be created from one month of data that commences on the specified date. If this option is omitted, the starting date defaults to "1".
Data from a given day is displayed after 9:00 AM on the next day.
Refer to "Scheduled Report Operation Command" in the Reference Guide for details on options and other information.
Usage example 1
The following example shows how to generate a daily report that begins at 9:00 am. It generates only reports where Business System A is specified for the registration conditions for scheduled reports.
> sqcMakeReport -c DefaultConsole -g Business System A -t 9 daily |
Usage example 2
The following uses registered scheduled reports to generate a daily report for 01 May 2012.
> sqcMakeReport -c DefaultConsole -s 20120501 -e 20120501 daily |
Note
When the Report Creation Command is executed, a number of pop-up messages such as the one shown below may open and then close on the Windows desktop momentarily.
These windows are displayed when data is extracted from a PDB. They do not indicate a problem.
If the command terminates abnormally with exception code 0xe06d7363, the desktop heap may be insufficient. Increase the size of the desktop heap by referring to "6.1 Content Display Errors".
These pop-up windows can be prevented by specifying a different user from the usual login user in the "Run as:" option when registering the command with the scheduler.
After executing the scheduled report creation command, check the results in the "5.4 Scheduled Report View".
