Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2000
Microsoft SQL Server 2000
SQL Server 2000 Books Online
Transact-SQL Reference
System Tables
backupfile
backupmediafamily
backupmediaset
backupset
logmarkhistory
log_shipping_databases
log_shipping_monitor
log_shipping_plan_databases
log_shipping_plan_history
log_shipping_plans
log_shipping_primaries
log_shipping_secondaries
MSagent_parameters
MSagent_profiles
MSarticles
MSdistpublishers
MSdistribution_agents
MSdistribution_history
MSdistributiondbs
MSdistributor
MSdynamicsnapshotjobs
MSdynamicsnapshotviews
MSlogreader_agents
MSlogreader_history
MSmerge_agents
MSmerge_altsyncpartners
MSmerge_contents
MSmerge_delete_conflicts
MSmerge_errorlineage
MSmerge_genhistory
MSmerge_history
MSmerge_replinfo
MSmerge_subscriptions
MSmerge_tombstone
MSpub_identity_range
MSpublication_access
MSpublications
MSpublisher_databases
MSqreader_agents
MSqreader_history
MSrepl_backup_lsns
MSrepl_commands
MSrepl_errors
MSrepl_identity_range
MSrepl_originators
MSrepl_transactions
MSrepl_version
MSreplication_objects
MSreplication_options
MSreplication_queue
MSreplication_subscriptions
MSsnapshot_agents
MSsnapshot_history
MSsubscriber_info
MSsubscriber_schedule
MSsubscription_agents
MSsubscription_articles
MSsubscription_properties
MSsubscriptions
Mssub_identity_range
MSsync_states
restorefile
restorefilegroup
restorehistory
sysalerts
sysaltfiles
sysarticles
sysarticleupdates
syscacheobjects
syscategories
syscharsets
syscolumns
syscomments
sysconfigures
sysconstraints
syscurconfigs
sysdatabases
sysdbmaintplan_databases
sysdbmaintplan_history
sysdbmaintplan_jobs
sysdbmaintplans
sysdepends
sysdevices
sysdownloadlist
sysfiles
sysfilegroups
sysforeignkeys
sysfulltextcatalogs
sysindexes
sysindexkeys
sysjobhistory
sysjobschedules
sysjobs
sysjobservers
sysjobsteps
syslanguages
syslockinfo
syslogins
sysmembers
sysmergearticles
sysmergepublications
sysmergeschemaarticles
sysmergeschemachange
sysmergesubscriptions
sysmergesubsetfilters
sysmessages
sysnotifications
sysobjects
sysoledbusers
sysopentapes
sysoperators
sysperfinfo
syspermissions
sysprocesses
sysprotects
syspublications
sysreferences
sysremotelogins
sysreplicationalerts
sysschemaarticles
sysservers
syssubscriptions
systargetservergroupmembers
systargetservergroups
systargetservers
systaskids
systypes
sysusers
Expand Minimize
This topic has not yet been rated - Rate this topic

sysdbmaintplan_jobs

SQL Server 2000

Contains one row for each maintenance plan job. This table is stored in the msdb database.

Column name Data type Description
plan_id uniqueidentifier Maintenance plan ID.
job_id uniqueidentifier ID of a job associated with the maintenance plan.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.