model

type DBJobService struct {
	// contains filtered or unexported fields
}

type DBOutcomeService struct {
	// contains filtered or unexported fields
}

type Job struct {
	ID              string      `db:"JobID" json:"job_id"`
	Name            string      `db:"JobName" json:"name"`
	Scheduled       bool        `db:"Scheduled" json:"scheduled"`
	Run             null.Time   `db:"LastRunDate" json:"run_date"`
	Duration        null.Float  `db:"DurationInSec" json:"run_duration"`
	AverageDuration null.Float  `db:"AvgDurationInSec" json:"avg_run_duration"`
	Result          null.String `db:"LastRunResult" json:"run_result"`
	NextRun         null.Time   `db:"NextRunDate" json:"next_run"`
}

type Outcome struct {
	InstanceID       int         `db:"instance_id"`
	JobID            []byte      `db:"job_id"`
	JobName          string      `db:"job_name"`
	StepID           int         `db:"step_id"`
	StepName         string      `db:"step_name"`
	SQLMessageID     int         `db:"sql_message_id"`
	SQLSeverity      int         `db:"sql_severity"`
	Message          string      `db:"message"`
	RunStatus        string      `db:"run_status"`
	RunDate          time.Time   `db:"run_date"`
	RunDuration      int         `db:"run_duration"`
	OperatorEmailed  null.String `db:"operator_emailed"`
	OperatorNetsent  null.String `db:"operator_netsent"`
	OperatorPaged    null.String `db:"operator_paged"`
	RetriesAttempted int         `db:"retries_attempted"`
	Server           string      `db:"server"`
}

type OutcomeQuery struct {
	JobID        string
	StartRunDate int // e.g. 20170724
	StartRunTime int // e.g. 91500 or 100500
}