[basemap]

Excellent, thanks very much, i'll give it a go

Regards

peterlaursen wrote on Dec 2 2005, 01:51 PM:

yes – I think you can

1) but I dont want to send an email

>>> then just choose 'run maintenaince query' on the first screen of the notification wizard

2) I would prefer to run a stored procedure

>>> your SQL to execute with the SJA job is then just

Code:

call `mydb`.`myproc`();

or

Code:

call `mydb`.`myproc`(parameterlist)

3) …command on an hourly basis between the hours of 8.am and 8pm 7 days a week

>>> See attached screenshot of Windows Scheduler.  It is all available from the 'advanced' settings.  Sorry it is in Danish (applies to language as well as time format)

Did I forget something?

[post=”8070″]<{POST_SNAPBACK}>[/post]

[Author]

Posts