JobServer.Script Method (ScriptingOptions)

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

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

Syntax

'Declaration
Public Function Script ( _
    scriptingOptions As ScriptingOptions _
) As StringCollection
public StringCollection Script (
    ScriptingOptions scriptingOptions
)
public:
virtual StringCollection^ Script (
    ScriptingOptions^ scriptingOptions
) sealed
public final StringCollection Script (
    ScriptingOptions scriptingOptions
)
public final function Script (
    scriptingOptions : ScriptingOptions
) : StringCollection

Parameter

  • scriptingOptions
    A ScriptingOptions object value that specifies the scripting options.

Rückgabewert

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

Hinweise

ms201624.note(de-de,SQL.90).gifHinweis:
The generated script might contain undocumented, internal procedures. These are required for the complete script output.

Der Namespace, die Klasse oder das Element wird nur in der Version 2.0 von Microsoft .NET Framework unterstützt.

Beispiel

How to: Script Out the Dependencies for a Database in Visual Basic .NET

Threadsicherheit

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plattformen

Entwicklungsplattformen

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Zielplattforme

Eine Liste der unterstützten Plattformen finden Sie unterHardware- und Softwareanforderungen für die Installation von SQL Server 2005.

Siehe auch

Verweis

JobServer Class
JobServer Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

Andere Ressourcen

Scripting
Automatisieren administrativer Tasks (SQL Server-Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent