Alert.Script Alert.Script Alert.Script Method

Definition

Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert.

Overloads

Script() Script() Script()

Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert.

Script(ScriptingOptions) Script(ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert as specified by the scripting options.

Script() Script() Script()

Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert.

public:
 virtual System::Collections::Specialized::StringCollection ^ Script();
public System.Collections.Specialized.StringCollection Script ();
Public Function Script () As StringCollection
Returns

A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implements

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Remarks

Note

The generated script might contain undocumented, internal procedures, which are required for the complete script output.

Script(ScriptingOptions) Script(ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert as specified by the scripting options.

public:
 virtual System::Collections::Specialized::StringCollection ^ Script(Microsoft::SqlServer::Management::Smo::ScriptingOptions ^ scriptingOptions);
public System.Collections.Specialized.StringCollection Script (Microsoft.SqlServer.Management.Smo.ScriptingOptions scriptingOptions);
Parameters
scriptingOptions
ScriptingOptions ScriptingOptions ScriptingOptions

A ScriptingOptions object value that specifies the scripting options.

Returns

A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implements

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

Remarks

Note

The generated script might contain undocumented, internal procedures, which are required for the complete script output.

Applies to