SQL-DMO Examples: Jobs and Schedules

SQL-DMO will be removed in the next version of Microsoft SQL Server. Avoid using SQL-DMO feature in new development work, and plan to modify applications that use SQL-DMO.

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.