#Assign variables
$Instance   = "localhost\SQL2012"
#Assign the SMO class to a variable
$SMO        = "Microsoft.SqlServer.Management.Smo"
 
# get the server
$Server = New-Object ("$SMO.Server") "$Instance"
 
$Job = $Server.JobServer.Jobs["Database Consistency Checks"]
IF (!($Job))
{
    # Create the job
    $Job = New-Object ("$SMO.Agent.Job") ($Server.JobServer, 'Database Consistency Checks')
    $Job.OwnerLoginName = 'sa'
    $Job.Create()
}
 
$JobStep = $Job.JobSteps["Run DBCC on all databases"]
IF (!($JobStep))
{
    # Create the job step to run DBCC CHECKDB for all databases
    $JobStep = New-Object ("$SMO.Agent.JobStep") ($Job, "Run DBCC on all databases")
    $JobStep.Command = "EXECUTE sp_msForEachDB 'DBCC CHECKDB([?])'"
    $JobStep.OnSuccessAction = [Microsoft.SqlServer.Management.Smo.Agent.StepCompletionAction]::QuitWithSuccess
    $JobStep.OnFailAction = [Microsoft.SqlServer.Management.Smo.Agent.StepCompletionAction]::QuitWithFailure
    $JobStep.Create()
}
 
$JobSchedule = $Job.JobSchedules["Saturday's at 3am"]
IF (!($JobSchedule))
{
    # Create the job schedule to run on Saturdays at 3am
    $JobSchedule = New-Object ("$SMO.Agent.JobSchedule") ($Job, "Saturday's at 3am")
    $JobSchedule.FrequencyTypes = [Microsoft.SqlServer.Management.Smo.Agent.FrequencyTypes]::Weekly
    $JobSchedule.FrequencyInterval = [Microsoft.SqlServer.Management.Smo.Agent.WeekDays]::Saturday
    $JobSchedule.FrequencyRecurrenceFactor = 1 # Run every 1 week
    $TimeSpanStart = New-Object -TypeName TimeSpan -ArgumentList 3,0,0
    $JobSchedule.ActiveStartTimeOfDay = $TimeSpanStart
    $JobSchedule.Create()
}