SAP Package SMSS_SQLJOBS
Database jobs for MS SQL Server
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The package SMSS_SQLJOBS (Database jobs for MS SQL Server) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | SMSS_SQLJOBS |
| Short Text | Database jobs for MS SQL Server |
| Parent Package | BASIS |
Function Groups
SAP Package SMSS_SQLJOBS contains 1 function groups.
| SFMSS_JOBS | Functions used by db12, db13 for MSSQL |
|---|
Transactions
SAP Package SMSS_SQLJOBS contains 1 transactions.
| DB12_MSS | Db12 Multiconnect transaction |
|---|
Structures
SAP Package SMSS_SQLJOBS contains 16 structures.
| AGENTINFO | Sqlserver Agent Information |
|---|---|
| MSQ_JOBS | MS SQL SERVER JOB description (as from msdb..sysjobs) |
| MSQ_JOBSID | MS SQL Server Job Id |
| MSQBACKMED | MS SQL SERVER BACKUP MEDIASETS |
| MSQBACKSET | MS SQL server backup list |
| MSQBAKFILE | Sqlserver Backup file information |
| MSQCCMSJOB | MS SQL server list of CCMS planned tasks |
| MSQDEVLIST | MS SQL server Backup device List. |
| MSQHISSTEP | Sql Server Job History Steps |
| MSQJBSHIS | MS SQL server Job History ( from msdb..sysjobhistory (7.0) |
| MSQJOBHDR | MS SQL server job header information |
| MSQJOBMESS | MS SQL server Job Message (from msdb..sysjobhistory) |
| MSQSCHEDUL | MS SQL server jobschedules ( as from msdb..sysjobschedules) |
| MSQSDBABI | INTTAB for Backup Scheduling |
| MSQSDBAHI | Internal Table for SDBA Results (Logs, Return Codes) |
| MSSSCHJOBS | List of sql agent jobs scheduled for the next X days |
Programs
SAP Package SMSS_SQLJOBS contains 5 programs.
| RSMSQ850 | Transaction DB12: Database Backup History |
|---|---|
| RSMSQADM | Database Administration and Backup Scheduling for MS SQL Server |
| RSMSQCCM | CCMS jobs |
| RSMSSLOG | MS SQL server Backups |
| RSMSSSCHEJOBS | List of scheduled agent jobs for the next 30 days |
Message Classes
SAP Package SMSS_SQLJOBS contains 1 message classes.
| SMMSS_SQLJOBS | Message class for SMSS_SQLJOBS |
|---|