Share via


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.

Examples

Using Collections

See Also

Reference

JobCollection Class

Script Overload

Microsoft.SqlServer.Management.Smo.Agent Namespace