Menu

SAP Package SMSS_SQLJOBS

Database jobs for MS SQL Server

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