Alert.Script Method

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

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Function Script As StringCollection
'Usage
Dim instance As Alert 
Dim returnValue As StringCollection 

returnValue = instance.Script()
public StringCollection Script()
public:
virtual StringCollection^ Script() sealed
abstract Script : unit -> StringCollection  
override Script : unit -> StringCollection
public final function Script() : StringCollection

Return Value

Type: System.Collections.Specialized.StringCollection
A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implements

IScriptable.Script()

Remarks

Note

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

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

Alert Class

Script Overload

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_help_alert (Transact-SQL)