SAP Function Group SFMSS_JOBS
Functions used by db12, db13 for MSSQL
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
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.
Technical Information
| Function Group | SFMSS_JOBS |
| Short Text | Functions used by db12, db13 for MSSQL |
| Package | SMSS_SQLJOBS |
Function Modules
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 |