Dummy input in Server Jobs

ArndW · Post by **ArndW** » Tue Jul 07, 2009 11:05 pm

You can create a server job without inputs. Create a transform stage with no inputs, define a stage var (you don't need to use it) and define a constraint such as "@OUTROWNUM<2" and you are done.

Kryt0n · Post by **Kryt0n** » Tue Jul 07, 2009 11:27 pm

Or create a sequence job, add a routine activity and call your routine from there... sounds like what you want anyway...

ray.wurlod · Post by **ray.wurlod** » Wed Jul 08, 2009 12:37 am

I like to use a hashed file stage invoking VOC with the Selection tab having @ID = 'VOC', or a sequential file stage accessing a file that is known to exist (such as uvodbc.config) and a filter of head -1.

lindatgeorge · Post by **lindatgeorge** » Wed Jul 08, 2009 12:37 am

Adding the stage variable and including the constraint resolved my issue.

Thanks a lot for all your help..