I am trying to trigger a sql agent job from a powershell script and I want to add powershell script and add it to  task scheduler. Here is where I am stuck.All I am trying to do is check if a new file exists at a specified location. if yes then execute a sql agent job else let me know file not exists

Import-Csv .\*.csv | ForEach {

    If (Test-Path -Path $_.File) {
--how do I trigger the sqlagent job

    } Else {

        Write-Output "No CSV file does NOT exist"


    }

}

This should help.

$Con = new-object System.Data.SqlClient.sqlConnection "server=<servernamehere>;database=msdb;Integrated Security=sspi"
$con.Open()
$cmd = $con.CreateCommand()
$cmd.CommandText = "EXEC dbo.sp_start_job N'<jobnamehere>'"
$cmd.ExecuteReader()
$con.Close()

You no need to do this kind of overhead for running the agent job.

If you are working with SQL agent that means you are using SQL edition other than Express edition.

You can schedule the agent job in the same was as you can do in task manager.

So that you can avoid scripting in powershell and again calling from task manager.

Hi SqlPUser,

Please check the below link .

http://www.johnsansom.com/script-sql-server-agent-jobs-using-powershell/