CreateAJob.ps1

cls

Set-Location "/home/richie/sqltoolservice/"

$Assem = (
    "Microsoft.SqlServer.Management.Sdk.Sfc",
    "Microsoft.SqlServer.Smo",
    "Microsoft.SqlServer.ConnectionInfo"
);

Add-Type -AssemblyName $Assem 

Function Connect-SqlConnection {
    [CmdletBinding()]
    param
    (
        $instance,
        $uname,
        $pword
    )
    $sqlConnection = new-object Microsoft.SqlServer.Management.Common.SqlConnectionInfo($instance, $uname, $pword)       
    try {
        Write-Host "Connecting..."
        $SqlSvr = New-Object Microsoft.SqlServer.Management.Smo.Server($SqlConnection)
        Write-Host "Connected!"
        return $SqlSvr
    }
    catch {
        throw $_.Exception.InnerException.ToString()
    }
}

$thisInstance = "localhost"
$thisUname = "sa"
$thisPword = ""

Write-Host "About to run..."
$thisSqlConn = Connect-SqlConnection -Instance $ThisInstance -Uname $thisUName -Pword $thisPword
$svrJobs = $thisSqlConn.JobServer.Jobs | Select-Object -ExpandProperty Name
$svrJobs
$jobName = "my_first_job"
$job = new-object ('Microsoft.SqlServer.Management.Smo.Agent.Job') ($thisSqlConn.JobServer, $jobName)
if ($svrJobs -notcontains $jobName) {
    try {
        $job.Create()
        $job.Refresh()
        Write-Host "SQL Agent Job $jobName created successfully."
    }
    catch {
        throw $_.Exception.InnerException.ToString()
    }
}