sys.sp_add_job

Description

Creates a new job executed by the SQL Server Agent service.

Syntax

sp_add_job
[ @job_name = ]
N
'job_name'
[ , [ @enabled = ] enabled ]
[ , [ @description = ]
N
'description'
]
[ , [ @start_step_id = ] step_id ]
[ , [ @category_name = ]
'category'
]
[ , [ @category_id = ] category_id ]
[ , [ @owner_login_name = ]
'login'
]
[ , [ @notify_level_eventlog = ] eventlog_level ]
[ , [ @notify_level_email = ] email_level ]
[ , [ @notify_level_netsend = ] netsend_level ]
[ , [ @notify_level_page = ] page_level ]
[ , [ @notify_email_operator_name = ]
'email_name'
]
[ , [ @notify_netsend_operator_name = ]
'netsend_name'
]
[ , [ @notify_page_operator_name = ]
'page_name'
]
[ , [ @delete_level = ] delete_level ]
[ , [ @job_id = ] job_id
OUTPUT
]
[ ; ]