SAP ABAP Function Module MSS_SQLAGENT_JOBS (Function to create, delete, modify sql agent jobs)
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_SQLAGENT_JOBS | Function to create, delete, modify sql agent jobs |
| Function Group | SFMSS_JOBS | Functions used by db12, db13 for MSSQL |
| Program Name | SAPLSFMSS_JOBS | |
| INCLUDE Name | LSFMSS_JOBSU19 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Exporting |
RETCODE | TYPE | MSQEXPORT-RETCODE | MS SQL server - error number of the last executed sql stmt | |||
 Importing |
SQLCOMMAND | TYPE | MSQIMPORT-COLULIST | MS SQL server - table column list | |||
| Importing |
SQLUPDCMD | TYPE | MSQIMPORT-COLULIST | MS SQL server - table column list | |||
| Importing |
ST_IMMED | TYPE | MSQEXPORT-OBJEXISTS | MSQ server - returns whe. the object exists in database | |||
| Importing |
CHK_DB | TYPE | MSQEXPORT-OBJEXISTS | MSQ server - returns whe. the object exists in database | |||
| Importing |
SIMULATION_MODE | TYPE | MSQEXPORT-OBJEXISTS | 'N' | MSQ server - returns whe. the object exists in database | ||
| Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name for a database connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | '' | Schema name | ||
 Tables |
BKUP_STMTS | TYPE | MSSEXESTMTS | DB6: Command Line | |||
 Exception |
DB_ERROR | TYPE | |||||
| Exception |
INTERNAL_ERROR | TYPE | |||||
| Exception |
CONNECT_ERROR | TYPE | |||||
| Exception |
NOT_RUNNING_ON_MSSQL | TYPE | |||||
| Exception |
SQLAGENT_NOT_RUNNING | TYPE | |||||
| Exception |
ERROR_JOB_RETCODE | 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 | 20010220 |
| SAP Release Created in |
