The package SMSS_SQLJOBS (Database jobs for MS SQL Server) is a standard package in SAP ERP. It belongs to the parent package BASIS.
| Package | SMSS_SQLJOBS |
| Short Text | Database jobs for MS SQL Server |
| Parent Package | BASIS |
SAP Package SMSS_SQLJOBS contains 1 function groups.
| SFMSS_JOBS | Functions used by db12, db13 for MSSQL |
|---|
SAP Package SMSS_SQLJOBS contains 1 transactions.
| DB12_MSS | Db12 Multiconnect transaction |
|---|
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 |
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 |
SAP Package SMSS_SQLJOBS contains 1 message classes.
| SMMSS_SQLJOBS | Message class for SMSS_SQLJOBS |
|---|