SAP ABAP Function Module ADD_JOB_MSQ (MS SQL server function to add a sql server job)
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 | ADD_JOB_MSQ | MS SQL server function to add a sql server job |
| Function Group | SFMSS_JOBS | Functions used by db12, db13 for MSSQL |
| Program Name | SAPLSFMSS_JOBS | |
| INCLUDE Name | LSFMSS_JOBSU01 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Exporting |
R_JOBID | TYPE | MSQSYSJOBS-JOBID | MS SQL server - error number of the last executed sql stmt | |||
 Importing |
TASKNAME | TYPE | MSQSYSJOBS-JOBNAME | ||||
| Importing |
DBNAME | TYPE | MSSDB | Database name | |||
| Importing |
DESCRIPTION | TYPE | MSQSYSJOBS-JOBDESC | ||||
| Importing |
ENABLED | TYPE | MSQSYSJOBS-ENABLED | ||||
| Importing |
COMMAND | TYPE | MSQJOBSTEP-JOBCOMMAND | ||||
| Importing |
SUBSYSTEM | TYPE | MSQJOBSTEP-SUBSYSTEM | 'TSQL' | |||
| Importing |
STEPNAME | TYPE | MSQJOBSTEP-STEPNAME | 'STEP1' | |||
| Importing |
STARTDATE | TYPE | MSQIMPORT-JOBDATE | ||||
| Importing |
STARTTIME | TYPE | MSQIMPORT-JOBTIME | ||||
| Importing |
FREQTYPE | TYPE | MSQIMPORT-FREQTYP | 1 | |||
| Importing |
FREQINT | TYPE | MSQIMPORT-FREQINT | 1 | |||
| Importing |
STEPID | TYPE | MSQJOBSTEP-STEPID | ||||
| Importing |
FREQUNITTYPE | TYPE | MSQIMPORT-FREQTYP | ||||
| Importing |
FREQUNITINT | TYPE | MSQIMPORT-FREQTYP | ||||
| Importing |
OWNER | TYPE | MSSUNAME | MS SQL Server user name | |||
| Importing |
CON_NAME | TYPE | DBCON-CON_NAME | 'DEFAULT' | Logical name for a database connection | ||
| Importing |
SCHEMA | TYPE | MSSSCHEMA | '' | Schema name | ||
 Exception |
DB_ERROR | TYPE | |||||
| Exception |
INTERNAL_ERROR | TYPE | |||||
| Exception |
CONNECT_ERROR | TYPE | |||||
| Exception |
NOT_RUNNING_ON_MSSQL | 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 | 20130604 |
| SAP Release Created in |
