xp_sqlagent_notify documentation

Type

SQL stored procedure

Description

none

Parameters

name datatype length in/out comment

@op_type nchar 1 IN
@job_id uniqueidentifier IN
@schedule_id int IN
@alert_id int IN
@action_type nchar 1 IN
@error_flag int IN
@wmi_namespace nvarchar 128 IN
@wmi_query nvarchar 512 IN

Usage

EXEC dbo.sp_sqlagent_notify
@op_type = @mynchar1,
@job_id = @myuniqueidentifier2,
@schedule_id = @myint3,
@alert_id = @myint4,
@action_type = @mynchar5,
@error_flag = @myint6,
@wmi_namespace = @mynvarchar7,
@wmi_query = @mynvarchar8
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s