SAP ABAP Function Module MSS_DELETE_SQLAGENT_JOB (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

Basic Data

Function Module	MSS_DELETE_SQLAGENT_JOB	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_JOBSU01

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	DEL_FLG	TYPE	MSQEXPORT-RETCODE		☑	☑	MS SQL server - table column list
Importing	CHK_DB	TYPE	MSQEXPORT-OBJEXISTS		☑	☑	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
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	20130604
SAP Release Created in