JAMS Developer Guide
SQLStoredProc Class Members
Fields  Properties  Methods 


MVPSI.JAMS.Activities.SQL Namespace : SQLStoredProc Class

The following tables list the members exposed by SQLStoredProc.

Public Constructors
 NameDescription
Public ConstructorDefault constructor  
Top
Protected Fields
 NameDescription
Protected FieldDefaults to true. Can be set to false to stop execution. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivity)
Top
Public Properties
 NameDescription
Public PropertyThe wait time before terminating the attempt to execute a command and generate an error.  
Public PropertyThe optional database connection string. If not supplied the connection string will be built from the stored procedure's details.  
Public PropertyThe name of the database that contains the stored procedure.  
Public Property (Inherited from System.Activities.Activity)
Public Property (Inherited from System.Activities.Activity)
Public PropertyJAMS server which the JAMS user resides on (will default to current server)  
Public PropertySpecifies the JAMS user credentials for running the procedure.  
Public PropertyThe optional path to output the results of the stored procedure. If not specified the results will be written to the Job's log.  
Public PropertyCollection of Properties  
Public PropertyThe name of the SQL Server and instance.  
Public PropertyThe name of the stored procedure to run.  
Public PropertySpecifies if windows authentication should be used.  
Top
Protected Properties
 NameDescription
Protected PropertyBy default, if an exception occurs during Task execution we log and rethrow. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected PropertyAllows the activity to induce idle. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected Property (Inherited from System.Activities.Activity)
Protected Property (Inherited from System.Activities.NativeActivity)
Protected PropertyGets or sets a user-defined object associated with the current async activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Top
Public Methods
 NameDescription
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodOverloaded. Used by JAMS to manage parameters for the stored procedure.  
Public MethodOverloaded. Used by JAMS to manage parameters for the stored procedure.  
Public MethodUsed by JAMS to manage parameters for the stored procedure.  
Public MethodResumes a bookmark created when starting an Activity. Supported responses are Release or Skip. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivity)
Public Method (Inherited from System.Activities.Activity)
Top
Protected Methods
 NameDescription
Protected MethodAbort Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodOverridden. Checks task result and logs any errors  
Protected MethodOverloaded. Registers Activity Metadata (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodCancels the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodExecutes the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodOverridden. Executes the SQLStoredProc Activity  
Protected MethodOverloaded.  (Inherited from System.Activities.NativeActivity)
Protected MethodOverridden. Retrieves the required values from the context.  
Protected Method (Inherited from System.Activities.NativeActivity)
Top
See Also

Reference

SQLStoredProc Class
MVPSI.JAMS.Activities.SQL Namespace