Execute Agent Job Backup script using C#

Question

Hello Friends I have SQL Agent Job backup script and i want to execute that SQL Agent Job backup script using C#. I tried using SqlCommand but no any luck. Thanks in advanced

Tapan Patel · Answer

Considering you have SQL script stored somewhere in the file system you can use SQLServer.ConnectionContext.ExectueNonQuery( string ScriptData). Please visit below link. http://stackoverflow.com/questions/650098/how-to-execute-an-sql-script-file-using-c-sharp Please mark it as an answer if it addresses the issue.

Bikesh Srivastava · Answer

Hi  Visit here. http://www.c-sharpcorner.com/myaccount/AuthorCreatedArticleDetails.aspx?Path=registration&iscomplete=true

Nitin Sontakke · Answer

Still the link given would be helpful to you. However just out of curiosity when you can schedule a job why do you want to execute it from C#. And if you just want to execute if from C# (and don't want to schedule it) then why create a job at all. Hope you understand what I mean.

Swapnil Nandane · Answer

Hello I dont have any scheduled job i just have one backup script of job and i want to execute with the help of c# that create job in SQL Agent jobs thanks

Nitin Sontakke · Answer

I am just assuming that you already have a scheduled job running but also want the facility to run it manually. You may want to look into this: https://msdn.microsoft.com/en-us/library/ms186757.aspx