Delen via

  • Artikel

JobCollection.Script Method (ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the collection of jobs as specified by the script 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
'Usage
Dim instance As JobCollection
Dim scriptingOptions As ScriptingOptions
Dim returnValue As StringCollection

returnValue = instance.Script(scriptingOptions)

public StringCollection Script(
    ScriptingOptions scriptingOptions
)

public:
StringCollection^ Script(
    ScriptingOptions^ scriptingOptions
)

member Script : 
        scriptingOptions:ScriptingOptions -> StringCollection 

public function Script(
    scriptingOptions : ScriptingOptions
) : StringCollection

Parameters

Return Value

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

Remarks

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

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