CODEWITHSUNDEEP
c#sql-serversql-agent-job
Sunny sun
Sunny sun

Reputation: 45

How can use C# to generate a script from jobs of SQL Server 2008?

I know that we can use SSMS to generate a script of the jobs of SQL Server. Now I want do this by C#, how ?

Upvotes: 0

Views: 612

Answers (2)

Jaison
Jaison

Reputation: 813

easy :

http://www.sqldbadiaries.com/2010/11/08/generate-script-of-all-jobs/

Upvotes: 1

Pondlife
Pondlife

Reputation: 16260

Smo: http://msdn.microsoft.com/en-us/library/ms202375.aspx

Upvotes: 2

Related Questions