how do we pass variable parameters to a scheduled job?

Thanks In Advance

This message has been edited. Last edited by: Kerry,

Your question is generic enough to suggest a read through the fabulous manual, but I will suggest one of many different methods (search this forum to find more): let's say your scheduled report fex has an amper variable called &CALENDAR_MONTH and the parameter to pass can be 1 to 12 and you want to run the schedule for month 6.

1) Make sure your scheduled fex has this line "WHERE CALENDAR_MONTH EQ &CALENDAR_MONTH"
2) Create a one record flat file with just "6" in it. Then have your report fex -READ this value into your &CALENDAR_MONTH variable.

That's one way. There are a few other ways, but the right one depends on what you are trying to do. If you could perhaps be a bit more detailed in your question?

This message has been edited. Last edited by: DavSmith,

David,

quote:

1) Make sure your scheduled fex has this line "WHERE &CALENDAR_MONTH EQ 6"

A bit cold down there in Dallas?? Hope they close the roof this weekend!!! GO PACK!

Did you mean:

WHERE CALENDAR_MONTH EQ '&CALENDAR_MONTH';


Say HI! to Edwin...

Tom

Simply, A scheduled Job is a One which also runs a FEX behind it.

So As usual, havin an &VAR in the FEX is the way to pass paramters.

The Job will ask for parameters when you run the schedule manually.

Or in case, if things are automated, Users are going to submit the schedules and It is going to run in Frequency, Other than the Data granularity(Daily,Weekly,Monthy) save the Param values as well as part of the DB and pass it while invoking the schedule....

Tom, I'm going to nick-name you Eagle-Eye-Fleagle! I've corrected the original post. Thanks!

Yes, it's a bit cold, and 6 inches of snow this morning...good thing I have a 4wd Jeep so the commute in was fun.

BTW, the roof at Jerry World will be closed.

I wonder how all the celebreties are handling the cold weather?

You know the Pack and Steelers are problems, historically, for Dallas fans, but I will say when I was 10 and watching the Ice Bowl, I was rooting for Bart Starr!

Edwin says hi back!

Take care.

David