Table: ServiceJob

Database schema and system attributes for ServiceJob.

Assembly

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 520

Class

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

CreatedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

CronExpression

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 240

Description

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

EnableHistory

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

HistoryCount

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

Id

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

IsActive

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsSystem

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

LastRunDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

LastRunDurationSeconds

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

LastRunSchedulerName

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 80

LastStatus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 100

LastStatusMessage

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

LastSuccessfulRunDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

ModifiedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Name

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

NotificationEmails

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 2000

NotificationStatus

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

AlertEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Description: The system email to use for sending an alert
  • Property Values:
    • includeInactive = False

AlertEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Email address to send alerts to errors occur (multiple address delimited with comma).

AlertPeriod

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of minutes to allow for communications to be sent before sending an alert.

AlertRecipients

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: A comma-delimited list of recipients that should receive the alert

ApiThrottle

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of milliseconds to wait between tightly-consecutive API calls to the external Chat system, helping to proactively avoid rate limiting.

AssessmentSystemEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Property Values:
    • includeInactive = False

BatchNamePrefix

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The batch prefix name to use when creating a new batch
  • Property Values:
    • ispassword = False

BlockTypeGuidReplacementPairs

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Key Value List
  • Description: The key-value pairs of replacement BlockType.Guid values, where the key is the existing BlockType.Guid and the value is the new BlockType.Guid. Blocks of BlockType.Guid == key will be replaced by blocks of BlockType.Guid == value in all sites, pages, and layouts.
  • Property Values:
    • displayvaluefirst = False

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for the SQL Query to complete. Leave blank to use the SQL default (30 seconds).

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for each step to complete.

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for the SQL Query to complete. Leave blank to use the default for this job (3600). Note, it could take several minutes, so you might want to set it at 3600 (60 minutes) or higher

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for each SQL command to complete. On a large database with lots of transactions, this could take several minutes or more.

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for each SQL command to complete. On a large database with lots of transactions, this could take several minutes or more.

CommandTimeout

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum amount of time (in seconds) to wait for each SQL command to complete. On a large database with lots of transactions, this could take several minutes or more.

ConnectionStatus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Defined Value
  • Description: The connection status to use for new individuals (default: 'Web Prospect'.)
  • Property Values:
    • allowmultiple = False
    • definedtype = 4
    • enhancedselection = False

CutoffDays

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of days past the initial requested date to stop sending reminders. After this cut-off, reminders will need to be sent manually by a person.

CutoffDays

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Just in case the Note Notification service hasn't run for a while, this is the max number of days between the note edited date and the notification.

DaysBack

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of days prior to the current date to use as the start date when querying for payments that were added or updated.

DaysKeepExceptions

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of days to keep exceptions in the exception log (default is 30 days.)

DefaultCampus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Campus
  • Description: The deafult campus to use for new people when their gift is not made a unique campus-specific fund.
  • Property Values:
    • includeInactive = False

Domain

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Domain name of your SMTP server

DuplicatePreventionDayRange

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: This setting will keep additional step records from being added if a step was already added within the number of days provided.

EligibleFollowers

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Security Role
  • Description: The group that contains individuals who should receive following suggestions

EligibleFollowers

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Security Role
  • Description: The group that contains individuals who should receive following event notification

EmailTemplate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Property Values:
    • includeInactive = False

EmailTemplate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Property Values:
    • includeInactive = False

ExpirationPeriod

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of days after a communication was created or scheduled to be sent when it should no longer be sent.

ExpiringCreditCardEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Description: The system communication template to use for the credit card expiration notice. The merge fields 'Person', 'Card' (the last four digits of the credit card), and 'Expiring' (the MM/YYYY of expiration) will be available to the email template.
  • Property Values:
    • includeInactive = False

GroupType

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Group Type
  • Description: The Group type to send attendance reminders for.

HowMany

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of history records to process on each run of this job.

LoginId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The login to impersonate when navigating to secured pages. Leave blank if secured pages should not be indexed.

MaxInvites

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Maximum number of times an invite should be sent

MinimumFragmentationPercentage

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The minimum fragmentation percentage for an index to be considered for re-indexing. If the fragmentation is below is amount nothing will be done. Default value is 10%.

NoteWatchNotificationEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Property Values:
    • includeInactive = False

NotificationGroup

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Group
  • Description: The group that should receive incoming notifications

Password

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: The password associated with the Login Id.
  • Property Values:
    • ispassword = True

Port

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Port of the email server

RebuildThresholdPercentage

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The threshold percentage where a REBUILD will be completed instead of a REORGANIZE. Default value is 30%.

RecordStatus

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Defined Value
  • Description: The record status to use for new individuals (default: 'Pending'.)
  • Property Values:
    • allowmultiple = False
    • definedtype = 2
    • enhancedselection = False

ReminderEveryDays

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: The number of days between reminder emails.

ResendInviteAfterNumberDays

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Integer
  • Description: Number of days after sending last invite to sign, that a new invite should be resent.

RootGroup

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Group
  • Description: Only people in or under this group will receive the schedule notifications.

RunIndexRebuild

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Determines if indexes should be rebuilt.

RunIntegrityCheck

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Determines if an integrity check should be performed. (Integrity checks are never run on Azure SQL databases, because Azure manages its own data integrity.)

RunStatisticsUpdate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Determines if the statistics should be updated.

SendReminders

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Text
  • Description: Comma delimited list of days after a group meets to send an additional reminder. For example, a value of '2,4' would result in an additional reminder getting sent two and four days after group meets if attendance was not entered.

ShouldKeepOldBlocks

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: Determines if old blocks should be kept instead of being deleted. By default, old blocks will be deleted.

SystemEmail

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: System Communication
  • Description: The system communication to use when sending reminder.
  • Property Values:
    • includeInactive = False

UsageType

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Single-Select
  • Description: The type of usage metrics to calculate.
  • Property Values:
    • enumSourceTypeKey = Rock.Jobs.UpdateEntityUsage+UsageType
    • fieldtype = rb
    • values = 0^Media Usage

WriteEraHistory

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean
  • Description: If enabled will write eRA records to the History table.