SAP ABAP Function Module GET_SQLERRORLOGS_MSQ (retrieve text of SQLServer errorlogs and the sqlagent.out)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
| Function Module | GET_SQLERRORLOGS_MSQ | retrieve text of SQLServer errorlogs and the sqlagent.out |
| Function Group | SMSSDATA | MSS: Cockpit Backend not from RAT |
| Program Name | SAPLSMSSDATA | |
| INCLUDE Name | LSMSSDATAU01 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Importing |
NUMERRORLOG | TYPE | MSQ_LSTAT-NUMLOG | number of SQL Server sql error or sql agent log to display | |||
| Importing |
NUMERRORLINES | TYPE | MSQ_LSTAT-NUMLINES | MS SQL server - size of the log file | |||
| Importing |
NUMAGTLOG | TYPE | MSQ_LSTAT-NUMLOG | number of SQL Server sql error or sql agent log to display | |||
| Importing |
NUMAGTLINES | TYPE | MSQ_LSTAT-NUMLINES | MS SQL server - size of the log file | |||
| Importing |
ERRSTARTLINE | TYPE | MSQ_LSTAT-NUMLINES | MS SQL server - size of the log file | |||
| Importing |
AGTSTARTLINE | TYPE | MSQ_LSTAT-NUMLINES | MS SQL server - size of the log file | |||
| Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name for a database connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | ' ' | Schema name | ||
 Tables |
LOGLIST | TYPE | MSQERROUT | SQLServer Error log data | |||
| Tables |
AGENTLIST | TYPE | MSQERROUT | SQLServer Agent log data | |||
| Tables |
LOGSTATS | TYPE | MSQ_LSTAT | SQL Server structure to hold stats on error or agent logs | |||
| Tables |
AGTSTATS | TYPE | MSQ_LSTAT | SQL Server structure to hold stats on error or agent logs | |||
 Exception |
NO_ERROR_FILE | TYPE | no sqlservr error log files found | ||||
| Exception |
CONNECT_ERROR | TYPE | |||||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20100421 |
| SAP Release Created in | 711 |
