February 14, 2008 at 12:37 pm
:cool:"Script Job as" option of the context help menu would allow 1 job to script at a time.
Is there a way to script all jobs with one shot?
thx
John Esraelo
Cheers,
John Esraelo
February 14, 2008 at 1:34 pm
you can create a script jobs task in SSIS
February 14, 2008 at 1:46 pm
wow, I got to try that...
This way, I don't have to worry what's being added or not, I will just call them all in...
thx
John Esraelo
Cheers,
John Esraelo
February 14, 2008 at 3:39 pm
You can script all your jobs in a moment using the script jobs task that is available.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 14, 2008 at 5:20 pm
are you referring to this method or something in that nature (see below):
---
' Microsoft SQL Server Integration Services Script Task
' Write scripts using Microsoft Visual Basic
' The ScriptMain class is the entry point of the Script Task.
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Class ScriptMain
' The execution engine calls this method when the task executes.
' To access the object model, use the Dts object. Connections, variables, events,
' and logging features are available as static members of the Dts class.
' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.
'
' To open Code and Text Editor Help, press F1.
' To open Object Browser, press Ctrl+Alt+J.
Public Sub Main()
'
' Add your code here
'
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
---
thx
John Esraelo
Cheers,
John Esraelo
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply