發行項
09/24/2010

JobServer 類別

The JobServer object represents the SQL Server Agent subsystem and the msdb database.

命名空間： Microsoft.SqlServer.Management.Smo.Agent
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public NotInheritable Class JobServer _
    Inherits SqlSmoObject _
    Implements IAlterable, IScriptable
'用途
Dim instance As JobServer

public sealed class JobServer : SqlSmoObject, 
    IAlterable, IScriptable

public ref class JobServer sealed : public SqlSmoObject, 
    IAlterable, IScriptable

[<SealedAttribute>]
type JobServer =  
    class
        inherit SqlSmoObject
        interface IAlterable
        interface IScriptable
    end

public final class JobServer extends SqlSmoObject implements IAlterable, IScriptable

備註

When you use the SQL Server Agent objects, you can reference them by using the JobServer object property of the Server object. It is not necessary to call the constructor for the JobServer object because it is automatically created when the constructor is called for the Server object.

[!附註]

If the CompatibilityLevel property for the MSDB database is set to Version70 SMO might throw an exception with a COLLATE error.

To get JobServer object properties, users must be a member of the SQLAgentUserRole database role on the MSDB database, or be a member of the sysadmin fixed server role.

To set JobServer object properties, users must be a member of the sysadmin fixed server role.

To run methods on the JobServer object, users must be a member of the sysadmin fixed server role.