JobStep.DatabaseName Property
Gets or sets the name of the database to which the job step command execution is confined.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DatabaseName As String
Get
Set
'Usage
Dim instance As JobStep
Dim value As String
value = instance.DatabaseName
instance.DatabaseName = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public string DatabaseName { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property String^ DatabaseName {
String^ get ();
void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DatabaseName : string with get, set
function get DatabaseName () : String
function set DatabaseName (value : String)
Property Value
Type: System.String
A String value that specifies the name of an existing database.
Remarks
Each step of a Microsoft SQL Server Agent job can execute in a specified database. Setting the DatabaseName property of a JobStep object directs the execution of the referenced job step.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace