This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 36%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
sql-server-management-objects-smo-programming-guide
smo-object-model-namespaces
using-smo-with-powershell-to-obtain-sql-server-job-information
I want to execute a agent job step through powershell, but I am a newbie for SQL server. I read the document and have some basic understanding, but I still haven't solved the problem.
$srv = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Server "BI-DEV-DB"
$jb = $srv.JobServer.Jobs
$jb.Start("LSD_SC") <<< This is modified according to using-smo-with-powershell-to-obtain-sql-server-job-information, but it didn't work$jp = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Agent.JobStep
$jp.OnSuccessAction(QuitWithSuccess)
$jp.OnSuccessStep(QuitWithSuccess) << I do not understand the role and usage of OnSuccessAction and OnSuccessStep, but I think these two functions are helpful to me$jr = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Agent.JobServer
$jr.Jobs.Start("LSD_SC") <<< According to my understanding, is there a start event in Microsoft.SqlServer.Management.Smo.Agent.JobServer?
Can anyone give me some help?
why that complicated, use DbaTools CmdLet => Start-DbaAgentJob
Thank you for your answer, I still have a question, how to get the result of the job execution?
I found that "Get-DbaAgentJobHistory" can get the execution result.
Hello @wajika
in addition:
Get-DbaAgentJobHistory returns all information on the executions still available on each instance(s) of the SQL Server submitted. The cleanup of SQL Agent history determines how many records are kept.
EnumJobHistory(JobHistoryFilter)
The EnumHistory method returns a DataTable object that enumerates the execution history of all jobs.
https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.management.smo.agent.jobserver.enumjobhistory?redirectedfrom=MSDN&view=sql-smo-160#Microsoft_SqlServer_Management_Smo_Agent_JobServer_EnumJobHistory_Microsoft_SqlServer_Management_Smo_Agent_JobHistoryFilter_
JobHistoryFilter Class
https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.management.smo.agent.jobhistoryfilter?redirectedfrom=MSDN&view=sql-smo-160
Hope this helps with your query!
--------
--If the reply is helpful, please Upvote and Accept as answer--
Thank you for your help and patience