SAP ABAP Function Module MSS_GET_JOB_INFO_AND_LOG (Function to get job and history info of a 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
Basic Data
Function Module MSS_GET_JOB_INFO_AND_LOG Function to get job and history info of a job  
Function Group SFMSS_JOBS   Functions used by db12, db13 for MSSQL  
Program Name SAPLSFMSS_JOBS    
INCLUDE Name LSFMSS_JOBSU27    
Parameters
Type Parameter Name Typing Associated Type Default value Optional Pass Value Short text
Importing LJOBID TYPE SDBAHI-SQLJOBID MS SQL server job id
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
               
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  20010320 
SAP Release Created in