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(236.8, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
hi all,
I am trying to write a method that launches an Agent job from an asp.net page, I need:
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.Agent;
I tried Project-> Add Reference, but found nothing when Searching for Microsoft.SqlServer.Management.
Any idea what I need to install and where do I get it?
Thanks,
elsvieta
write a method that launches an Agent job
Easier way is with a SQL command + plain SQL with sp_start_job (Transact-SQL)
Thank you, Olaf
I have tried
using (SqlCommand command = new SqlCommand("exec msdb.dbo.sp_start_job N'" + agentJobName + "';", connection))
with some correct argument for agentJobName and with a connection that is open and I know it is working correctly.
I get an error that says the job is not found:
System.Data.SqlClient.SqlException (0x80131904):
The specified @job_name ('myJob') does not exist.
The IIS user which is a login in the database is mapped to msdb and has granted execution on sp_start_job.
How come it does not find the job?
Thanks,
elsvieta
![](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(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Hi @elsvieta,
Have you ever tried running a SQL statement directly in the database to see if an error is reported?
Lan Huang,
I did, it's just that the statement was executed from a web page within an ASP.NET project.
I guess in this case the user is whatever account runs under the IIS. I asked the dba to fix the issue. It was fixed after that account was granted the SQLAgentOperator role.
Try to use the “Manage NuGet Packages...” command for your project, go to Browse tab, find and install the Microsoft.SqlServer.SqlManagementObjects package.
Hi @elsvieta,
Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO.
Creating a Visual C# SMO project in Visual Studio.NET
Best regards,
Lan Huang
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.