Scheduled Job

[basemap]

Hi I have mySQL 5.15 and Webyog enterprise. Is there anyway I can schedule a SQL Update command on an hourly basis between the hours of 8.am and 8pm 7 days a week, i.e. update a record based upon a value in the record. I would prefer to run a stored procedure that way i can maintain the code easily.

I can use the Notification job wizard, but I dont want to send an email

Thanks

Richard

[peterlaursen]

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?

[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]

[peterlaursen]

@ritesh

this

Code:

call `mydb`.`myproc`(parameterlist)

gave me an idea for the future: an ability to dynamically pass parametres to SP's and functions from SJA/Notifications Wizards will really rock the boat!

like

Code:

anyone out there using SP's extensively who could tell what facilities would be useful ?

[Ritesh]

Added in our TO-DO list 😀

Looks interesting. Any more ideas?

[Author]

Posts