InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 02:04:12 GMT20http://www.sqlservercentral.com/Forums/Topic910463-22-1.aspxHi,I have the following code that scripts out all agent jobs on a server. I want the generated script to include If not exists condition coz i either want to skip or overwrite existing jobs.Dim ArgObjDim xDim ServerNameSet ArgObj=Wscript.Argumentsx=ArgObj.Item(0)ServerName=Mid(x,3)Wscript.Echo(ServerName)Dim oSQLServer Dim oStream Set oSQlServer = CreateObject("SQLDMO.SQLServer") Set oStream = CreateObject("ADODB.Stream") oSQLServer.LoginSecure=TrueoSQLServer.Connect ServerNameDim idStep Dim ScriptJob Dim CountJobs Dim JobName Dim ScriptAllJobsFor Each oJob In oSQLServer.JobServer.Jobs JobName = oJob.Name if (InStr(UCase(JobName), "MIRRORING") > 0) Then Wscript.Echo("Skipping Job"&JobName) else ScriptJob = Replace(oJob.Script(4,"C:\"& JobName &".sql") , ServerName, "(local)") ScriptAllJobs = ScriptAllJobs & ScriptJob End If NextoStream.Open oStream.WriteText (ScriptAllJobs) oStream.SaveToFile ("C:\SQLAllScripts.sql"), 2oStream.Close oSQLServer.DisConnectSet oStream = Nothing Set oSQLServer = Nothing Set ArgObj=NothingWhere and how do i implement in this code?Mon, 26 Apr 2010 09:12:35 GMTcoolchaitu