SQL-DMO Examples: Jobs and Schedules

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Jobs and schedules examples illustrate creating and scheduling SQL Server Agent jobs.

A SQL Server Agent job is named and contains at least one job step. A job step stores a command or language string defining an administrative task.

A job can be run by SQL Server Agent when it contains at least one step and an execution target. A job can be scheduled, and when scheduled, SQL Server Agent will run the job as directed by the schedules assigned to the job.