The Function Group SFMSS_JOBS (Functions used by db12, db13 for MSSQL) is a standard Function Group in SAP ERP and is part of the package SMSS_SQLJOBS. It contains the following embedded function modules and dictionary objects.
| Function Group | SFMSS_JOBS |
| Short Text | Functions used by db12, db13 for MSSQL |
| Package | SMSS_SQLJOBS |
Function Group SFMSS_JOBS contains 30 function modules.
| ADD_JOB_MSQ | MS SQL server function to add a sql server job |
|---|---|
| FILL_RESULT_TABLE_MSS | |
| GET_BACKUP_FILE | MS SQL server function to get the list of SAP Job Backup File |
| GET_BACKUP_LIST_MSQ | MS SQL server function to get the list of SAP backups |
| GET_CCMS_JOB_MSQ | MS SQL server function to get the list of SAP CCMS planned task |
| GET_CCMS_SINGLEJOB_STATUS_MSS | MS SQL server function to get the list of SAP CCMS planned task |
| GET_CCMS_TASK_MSQ | MS SQL server function to get the list of SAP CCMS planned task |
| GET_DBA_RESULTS_MSS | |
| GET_JOB_HIST_MESSAGE | MS SQL server function to get the list of SAP Job History Messages |
| GET_JOB_HIST_STEPS | MS SQL server function to get the list of SAP Job History Steps |
| GET_JOBS_FOR_CURR_DISPLAY | Function to get jobs scheduled in DB13 Display |
| MSS_CHECK_JOB_EXISTS | Function to check job exists in sql server |
| MSS_GET_BACKUP_DETAIL | Function to get backup details |
| MSS_GET_BACKUP_DEVICES | Function to get the list of backup devices. |
| MSS_GET_BACKUP_HIST | Function to get backup history overview |
| MSS_GET_DB_DEV_AND_USR_INFO | To get dbs, devices and user info |
| MSS_GET_JOB_AND_HISTORY_INFO | Function to get job and history info |
| MSS_GET_JOB_DETS | Function to get basic information of db13 jobs |
| MSS_GET_JOB_HEADERS | Function to get job history header information |
| MSS_GET_JOB_INFO_AND_LOG | Function to get job and history info of a job |
| MSS_GET_JOB_SCHEDULE_DETS | Function to get job schedule information |
| MSS_GET_JOBHIST_DETS | Function to get job history details |
| MSS_GET_JOBSTEP_DETS | Function to get job step details |
| MSS_GET_RESTORE_HIST | Function to get the restore history |
| MSS_GET_SCH_AGENT_JOBS | To get the ist of schduled jobs in next XX days. |
| MSS_GET_SQLAGENT_PROPERTIES | Function to get sqlagent properties |
| MSS_SQLAGENT_JOBS | Function to create, delete, modify sql agent jobs |
| MSS_START_SQLAGENT_JOB | Function to create, delete, modify sql agent jobs |
| SHOW_DBA_RESULTS_MSS | |
| UPDATE_JOB_MSQ | MS SQL server function to enable/disable the job |