SAP ABAP Function Module MSS_GET_JOB_AND_HISTORY_INFO (Function to get job and history info)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_SQLJOBS (Package) Database Jobs for MS SQL Server
Basic Data
| Function Module | MSS_GET_JOB_AND_HISTORY_INFO | Function to get job and history info |
| Function Group | SFMSS_JOBS | Functions used by db12, db13 for MSSQL |
| Program Name | SAPLSFMSS_JOBS | |
| INCLUDE Name | LSFMSS_JOBSU22 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Importing |
FROM_TIMESTAMP | TYPE | SDBAHS-BEG | Start of the DBA action | |||
| Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name for a database connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | '' | Schema name | ||
 Tables |
BASJOBLST | TYPE | MSQ_JOBS | MS SQL SERVER JOB description (as from msdb..sysjobs) | |||
| Tables |
TASKLIST | TYPE | MSQJOBMESS | MS SQL server Job Message (from msdb..sysjobhistory) | |||
| Tables |
JBSCHEDULE | TYPE | MSQSCHEDUL | MS SQL server jobschedules ( as from msdb..sysjobschedules) | |||
| Tables |
JBSTEPDETS | TYPE | MSQJOBSTEP | MS SQL server jobsteps ( as from msdb..sysjobsteps) | |||
| Tables |
JBHISTDETS | TYPE | MSQJBSHIS | MS SQL server Job History ( from msdb..sysjobhistory (7.0) | |||
 Exception |
DB_ERROR | TYPE | |||||
| Exception |
INTERNAL_ERROR | TYPE | |||||
| Exception |
CONNECT_ERROR | TYPE | |||||
| Exception |
NOT_RUNNING_ON_MSSQL | TYPE | |||||
| Exception |
SYSTEM_FAILURE | 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 | 20010309 |
| SAP Release Created in |
