How can I setup my database for scheduler. Does scheduler
create certain tables or do tables have to be created manually?

The 24x7 Scheduler does not use any external databases and does not create any tables. If you wish you can export schedulers jobs, logs and other data to an external database of your choice using Tools/Import-Export Job Database menu

: How can I setup my database for scheduler. Does scheduler
: create certain tables or do tables have to be created manually?

Thanks.

If one of my daily jobs takes in a parameter that will change
daily based on date, how will that work in this job scheduler?

: The 24x7 Scheduler does not use any external databases and does not create
: any tables. If you wish you can export schedulers jobs, logs and other
: data to an external database of your choice using Tools/Import-Export Job
: Database menu

Check "Macro-parameters" topic in the on-line. I think there you will find answer for your question.

: Thanks.

: If one of my daily jobs takes in a parameter that will change
: daily based on date, how will that work in this job scheduler?

I would like it to be able to calculate parameters. For example, run an
sql job for data from 3 days ago, so the date passed will always be today-3.
Macro-parameters seem to pass just current information, and doesn't allow for calculating
parameters.

: Check "Macro-parameters" topic in the on-line. I think there you
: will find answer for your question.

If you run a 24x7 SQL job (a.k.a. database job) you can do date calculation within the job SQL. 24x7 supports multiple SQL statements in a single SQL job as long as they conform to your database standard.

If you run some other job change the job type to script (either JAL or VB) and do your date calculating there, for example in a JAL job you can do the following

Dim command, string
Dim my_date, date
Dim process_id, number
Dim formated_date, string

Today my_date
DateAdd my_date, -3, my_date
Format my_date, "mm-dd-yyyy", formated_date
ConcatEx "c:\\programs\\myprogram.exe ", formated_date, command
Run command, "", process_id

Please note that if your program name or path contain spaces the entire name must be enclosed in double-quotes

: I would like it to be able to calculate parameters. For example, run an
: sql job for data from 3 days ago, so the date passed will always be today-3.
: Macro-parameters seem to pass just current information, and doesn't allow for
: calculating
: parameters.