JAMS 6.x Help
SQLStoredProc Class Members
Fields  Properties  Methods 


The following tables list the members exposed by SQLStoredProc.

Public Constructors
 NameDescription
Public ConstructorSQLStoredProc ConstructorDefault constructor  
Top
Protected Fields
 NameDescription
Protected FieldContinueExecutionDefaults to true. Can be set to false to stop execution. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivity)
Top
Public Properties
 NameDescription
Public PropertyCommandTimeoutThe wait time before terminating the attempt to execute a command and generate an error.  
Public PropertyConnectionStringThe optional database connection string. If not supplied the connection string will be built from the stored procedure's details.  
Public PropertyDatabaseNameThe name of the database that contains the stored procedure.  
Public PropertyDisplayName (Inherited from System.Activities.Activity)
Public PropertyId (Inherited from System.Activities.Activity)
Public PropertyJAMSServerJAMS server which the JAMS user resides on (will default to current server)  
Public PropertyJAMSUsernameSpecifies the JAMS user credentials for running the procedure.  
Public PropertyOutputPathThe optional path to output the results of the stored procedure. If not specified the results will be written to the Job's log.  
Public PropertyPropertiesCollection of Properties  
Public PropertyServerNameThe name of the SQL Server and instance.  
Public PropertyStoredProcNameThe name of the stored procedure to run.  
Public PropertyUseWindowsAuthenticationSpecifies if windows authentication should be used.  
Top
Protected Properties
 NameDescription
Protected PropertyAbortOnTaskFailureBy default, if an exception occurs during Task execution we log and rethrow. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected PropertyCanInduceIdleAllows the activity to induce idle. (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected PropertyConstraints (Inherited from System.Activities.Activity)
Protected PropertyImplementation (Inherited from System.Activities.NativeActivity)
Protected PropertyUserStateGets or sets a user-defined object associated with the current async activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Top
Public Methods
 NameDescription
Public MethodGetAttributesUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetClassNameUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetComponentNameUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetConverterUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetDefaultEventUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetDefaultPropertyUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetEditorUsed by JAMS to manage parameters for the stored procedure.  
Public MethodGetEventsOverloaded. Used by JAMS to manage parameters for the stored procedure.  
Public MethodGetPropertiesOverloaded. Used by JAMS to manage parameters for the stored procedure.  
Public MethodGetPropertyOwnerUsed by JAMS to manage parameters for the stored procedure.  
Public MethodResumeCommandBookmarkResumes a bookmark created when starting an Activity. Supported responses are Release or Skip. (Inherited from MVPSI.JAMS.Activities.JAMSNativeActivity)
Public MethodToString (Inherited from System.Activities.Activity)
Top
Protected Methods
 NameDescription
Protected MethodAbortAbort Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodAfterExecuteOverridden. Checks task result and logs any errors  
Protected MethodCacheMetadataOverloaded. Registers Activity Metadata (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodCancelCancels the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodExecuteExecutes the Activity (Inherited from MVPSI.JAMS.Activities.NonblockingNativeActivity)
Protected MethodExecuteNonblockingOverridden. Executes the SQLStoredProc Activity  
Protected MethodOnCreateDynamicUpdateMapOverloaded.  (Inherited from System.Activities.NativeActivity)
Protected MethodPrepareToExecuteOverridden. Retrieves the required values from the context.  
Protected MethodUpdateInstance (Inherited from System.Activities.NativeActivity)
Top
See Also

Reference

SQLStoredProc Class
MVPSI.JAMS.Activities.SQL Namespace

Send Feedback