Execute Agent Job Backup script using C#

Considering, you have SQL script stored somewhere in the file system, you can use

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.

0

Hi ,

Visit here.

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

0

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.

0

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

0

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

0