HORIZONT Software for Datacenters

2. Topics TWS/WebAdmin Features Getting Started TWS Database Management Plan Monitoring and Management Job Notes Reporting Events and Alerts Miscellaneous Functions Other New Features in Version 2.0

3. TWS/WebAdmin Features Web Interface to Tivoli Workload Scheduler for Distributed (Unix and Windows) TWS Database Management – composer functions TWS Plan Management – conman functions Event Monitoring Alerting (Email and Custom Alerts) Job Notes Reporting: Customizable reports, charts and graphs, flexible SQL query engine

4. Getting Started Logging In TWS/WebAdmin Home Page Basic Navigation Help Printing Administration Page

5. Logging In Launch web browser, enter the name of the TWS Master in the address bar. Enter user name and password

6. TWS/WebAdmin Home Page

7. Basic Navigation TWS/WebAdmin display consists of 2 frames Navigation frame on left Results frame on right

8. Getting Help

9. Online Help Window

10. Printing from TWS/WebAdmin

11. TWS/WebAdmin Administration Page

12. Administration Home Page

13. Database Management Database Management Functions Object Definition Lists Common Database Management Actions Using Filters Backups Drafts Advanced Database Management Actions: Text Edit, Export, Dependent Objects

14. Database Management Functions Create, Modify, and Delete TWS Scheduling Objects Display and Edit object definitions in GUI mode or text mode Save Draft copies of Job and Jobstream definitions Export definitions to files for migration and backups View dependent objects and Notes

15. TWS Database Scheduling Objects Workstations Workstation Classes Domains Jobs Jobstreams Calendars Resources Prompts Parameters Users

16. Workstation Definitions

17. Workstation Class Definitions

18. Domain Definitions

19. Job Definitions

20. Jobstream Definitions

21. Calendar Definitions

22. Resource Definitions

23. Prompt Definitions

24. Parameter Definitions

25. User Definitions

26. Common Database Management Actions Click on an object name to display its definition (read-only) Standard Actions: Add, Modify, Delete Display: Show text definitions (multiple objects can be selected) Copy: Duplicate an existing object

27. Example: Display Workstation

28. Example: Display Workstation

29. Example: Display Workstation (Text)

30. Example: Display Workstation (Text)

31. Example: Add Calendar

32. Example: Add Calendar

33. Example: Modify Job

34. Example: Modify Job (Confirmation)

35. Example: Delete Jobstream

36. Example: Delete Jobstream

37. Using Filters Click the Filter action button on any Database List page to display filter options Current filter settings are displayed in the top left corner of Database Lists Click Clear Filter on filter page to clear filter settings Filter settings can be saved, restored, and bookmarked Click Database Filters in the navigation frame to go directly to a filter page

38. Database Filter Example

39. Database Filter Set

40. Database Filters Screenshot

41. Backups All Database Management actions that modify or delete scheduling objects provide an option to save a backup copy of the original definition(s) Backups are stored as text files which can be restored using TWS/WebAdmin or command line composer Backups are saved to the webadmin/backup directory with date/time and username stamp

42. Save Backup Example: Modify Job

43. Save Backup Example: Delete Prompt

44. Backup Options

45. Drafts Drafts are partial or complete Job and Jobstream definitions that are saved as text files Drafts are not saved to the TWS Mozart database, but can be recalled later to be reviewed, modified, and saved Drafts are stored with date/time and username stamps Users that do not have ADD permission for jobs and jobstreams in TWS security can be configured to have Save Draft permissions. This is valuable when implementing an approval process for TWS scheduling.

46. Save Draft Example

47. Save Draft Example

48. Saved Drafts

49. Advanced Database Management Actions Text Edit: Modify object definitions in command line mode – Useful for making mass changes to multiple definitions Export: Save object definitions to a local or remote file – Useful for backups and migrations Dependent Objects: Show all references to a selected object – Where it is used, what it is a member of, dependencies on it

50. Text Edit Jobs Example

51. Dependent Objects Example 1

52. Dependent Objects Example 2

53. Plan Monitoring and Management Basic Plan Monitoring Plan Management Actions Using Filters Submitting Ad-Hoc Jobs and Jobstreams Viewing Previous Production Days Forecasting TWS/WebAdmin Options

54. Basic Plan Monitoring Plan Monitoring / Management is performed in real time Very fast compared to Job Scheduling Console Workstations Domains Jobstreams Jobs Resources Prompts Files

55. Plan Workstation List

56. Plan Domain List

57. Plan Jobstream List

58. Plan Job List

59. Plan Resource List

60. Plan Prompt List

61. Plan File List

62. View Job Output Click on a job in the Plan Job List to display its output (stdlist) Job output is displayed in a new browser window Tail action displays job output in a constantly updating window - useful for “watching” a currently executing job

63. Job Output

64. Customize Plan List Layout The Layout action button on each Plan List page will customize the table column layout Select and re-order columns The Fill Entire Page Width option determines whether to stretch the table to fill the entire page Select Reset to Defaults to restore the standard default column layout

65. Custom Layout Example – Plan Jobstreams

66. Custom Layout Example – Plan Jobstreams

67. Custom Jobstreams Layout Example – Results

68. Plan List Sorting

69. Plan Management Actions All standard TWS plan actions are provided: Cancel, Release, Rerun, Priority, Limit, Fence, etc. Multiple objects can be selected Safe mode is used when canceling multiple jobs or jobstreams Unique Actions: Display Jobstream, Tail Job, Info

70. Using Filters Click the Filter action button on any Plan List page to display filter options Current filter settings are displayed in the top left corner of Plan Lists Click Clear Filter on filter page to clear filter settings Filter settings can be saved, restored, and bookmarked

71. Plan Filter Example

72. Load Filter Example

73. Set Filter Example

74. Plan Filters Click the Plan Filters in the navigation frame to go directly to a filter page Set / Load a filter prior to viewing a Plan List Useful if a Plan List contains a very large number of objects

75. Plan Filters Screenshot

76. Submitting Jobs and Jobstreams Submit Jobstream Submit Job Submit Task Dependencies and Alias can be specified Submit Jobstream, Submit Job, Submit Task links on Navigation frame Submit Jobstream and Submit Job on Plan Workstation List Submit Job on Plan Jobstream List

77. Submit Jobstream

78. Submit Job

79. Submit Task

80. Viewing Previous Production Days Set Run History displays a list of logged Symphony files Select the desired run date, then click Set Symphony All Plan Lists will display information from the selected production day Plan List title bars turn green while a previous production day is in use Return to Set Run History and click Use Current to return to the current day

81. Set Run History

82. Previous Production Day Job List

83. Forecasts The TWS/WebAdmin forecast function generates a complete forecast for a future production day Select Forecast, enter a future date, then click Generate All Plan Lists will display information from the future production day (just like viewing a previous production day)

84. Generate Forecast

85. Forecast Job List

86. TWS/WebAdmin Options Auto-Refresh Display Job Logs: Single / Multiple After Actions GoTo Action Buttons: Top / Bottom, Anchored Date Format Skin Compression Disable Job Statistics

87. TWS/WebAdmin Options

88. Auto Refresh Set any auto-refresh rate for Plan Lists Use the browser Reload button to force a manual refresh

89. Display Job Logs: Single / Multiple Single (default) displays only one stdlist when a job’s output is viewed Multiple displays all stdlists for a job (EVERY and RERUN jobs)

90. Action Buttons: Top / Bottom, Anchored Bottom (default): Action buttons are displayed at the bottom of the page Bottom (Anchored): Action buttons are anchored in a separate frame at the bottom of the page so they are always visible Top (Anchored): Action buttons are anchored in a separate frame at the top of the page so they are always visible

91. Action Buttons: Bottom (Anchored)

92. Date Format MM / DD / YYYY MM – DD – YYYY DD / MM / YYYY DD – MM – YYYY YYYY / MM / DD YYYY – MM – DD

93. Skin

94. Job Notes TWS/WebAdmin Job Notes are small text notes that are connected to specific jobs. Primary functions: Contact Information, Recovery Procedures, Comments. Simple HTML can be embedded: formatting, hyperlinks, bullet-lists, etc. Workstation Notes Notes are also accessible from Database Lists

95. Creating and Managing Job Notes To view Job Notes, select a job from the Plan Job List page or Database Job List page and click Notes From the Job Notes page, users can Add, Modify, and Delete Notes

96. Display Job Notes

97. Adding a Job Note

98. Adding a Job Note

99. Modifying Job Notes

100. Workstation Notes

101. Reporting TWS/WebAdmin provides a number of reports that can be generated and viewed from a web browser Charts and Graphs Reports can be customized and saved Report output can be stored Some reports can be generated and sent to Microsoft Excel in CSV format

102. Standard TWS/WebAdmin Reports Job History Report Job Details Report TWS Activity Report Production Planning Report TWS Database Report Cross Reference Report Critical Jobs Report

103. Job History Report Shows historical job execution information Select date range, job / jobstream / workstation names, job status Sort by date, job name, status, etc. Status Pie Chart

104. Job History Report - Example

105. Job History Report - Output

106. Job History Status - Pie Chart

107. Job Details Report Shows details and statistics for a specified job Presents a view of historical execution time in bar chart or line chart

108. Job Details Report - Example

109. Job Details Report - Output

110. Job Details Report - Bar Chart

111. TWS Activity Report Shows number of jobs executed per day by week / month / year Bar or line chart views Workstation can optionally be specified Jobs can be grouped by status using accumulated graphs

112. TWS Activity Report - Examples

113. TWS Activity Report – Month Activity Bar Chart

114. TWS Activity Report – Week Accumulated Bar Chart

115. Production Planning Report Generates a pre-production report for a range of future dates Shows jobstreams, descriptions, and estimated run times

116. Production Planning Report - Example

117. Production Planning Report - Output

118. Critical Jobs Report Define one or more lists of Critical jobs, including Deadline Time Critical Jobs Report shows the status of each critical job and whether it completed by the deadline Select which Plan to analyze: Current plan, yesterday's plan, or any previous logged plan

119. Critical Jobs Report - Example

120. Manage Critical Jobs List

121. Critical Jobs Report - Output

122. Creating Custom Reports TWS/WebAdmin extracts and stores TWS object definitions and job history data in a relational database (RDBMS) Customized reports are created with standard SQL Basic understanding of SQL syntax and the TWS/WebAdmin table structure is required

123. Example Custom Report Objective: Create a report that lists all jobs created by user “maestro” with a description that contains the text “extract” SQL Statement:SELECT * FROM jobs WHERE creator='maestro' AND description LIKE '%extract%'

124. Example Custom Report Setup

125. Example Custom Report Output

126. Saving Customized Reports Save Report function saves a customized report definition SQL Query, Title, and Report Description are stored Saved Reports are globally available from User Defined Reports menu item

127. Save Report Example

128. User Defined Reports

129. Storing Reports Storing a report saves the raw report output to a globally available URL Contents of stored reports are static URL can be emailed or posted as a link on an external web page

130. Store Report Example

131. Store Report Results

132. Microsoft Excel Integration Send as CSV File, available in several reports, sends report data in CSV (comma separated values) format By default, Excel is associated with the .csv file type and will launch automatically It may be necessary to resize columns in Excel following import

133. Send as CSV Example

134. Open CSV Data Stream

135. View CSV in Excel

136. Events and Alerting TWS/WebAdmin Event Monitor collects events from TWS Job Abend, Jobstream Stuck, CPU Link Down, etc. Custom events and severities Alerts: Email and custom commands

137. Event Monitor

138. Event Configuration

139. Alerts TWS/WebAdmin alerts generate email notification for events such as Job Abends Wildcards are permitted Multiple email addresses can be entered, separated by commas Enter custom email text in the Email Text field or leave blank to use the default email format Instead of sending email, an alert can execute a custom command

140. Alert Configuration

141. Adding an Alert

142. Miscellaneous Functions Audit Log Viewer TWS Logfile Viewer TWS Mailbox Files TWS Database Files

143. Audit Log Viewer Displays TWS Database and Plan Audit Logs Auditing must be enabled in the TWS globalopts file Entries can be filtered Send as CSV displays log entries in MS Excel

144. Database Audit Log

145. Plan Audit Log

146. TWS Logfile Viewer TWS maintains the MAESTRO logfile, which contains a running log of TWS operations, including errors and warnings The TWS/WebAdmin Logfile viewer simply displays the MAESTRO logfile and allows filtering and navigation by date Useful for troubleshooting

147. TWS Logfile Example

148. TWS Mailbox Files

149. TWS Database Files

150. Other New Features in Version 2.0 Execute TWS/WebAdmin Reports from command line (scheduling reports now possible) New options for extracts, improved performance for extracts, new Current-Plan extracts New NOP action for Plan jobs and jobstreams, New Rerun: Step action for jobs Improved page refreshing, new R refresh hotkey Pop-up selectors filter on partially entered names Enhanced control of user permissions, global filters, and saved reports Improved maintenance utilities in TWS/WebAdmin Administration

151. Upcoming Features Composer Versioning, Migration Tool Enhanced SAP Extended Agent Job Configuration TWS Database Validation (Health Check) Critical Path Monitoring TWS/Graph Integration Additional Language support

152. Conclusion Wrap Up Questions Comments Additional Resources:www.horizont-it.com (Europe)www.segus.com (USA)Email: info@segus.com