prescheduled execution of stored procedures 1

[samasamajam]

plss tell me how to schedule execution of shell scripts at regular intervals which inturn execute stored procedures

 

[dickiebird]

You'd have to create an entry in a crontab - either root cron or the cron of a regular user, using crontab -e
e.g
00 13 ** 5 /runtime/scripts/myscript
which will run every Friday at 1pm
and that script would contain the call to the stored procedure
eg (sybase example)
#!/bin/ksh
isql -b -Uuserid -Ppassword <<EOP
exec yourproc
go
EOP

or for Oracle :
#!/bin/ksh
sqlplus -s userid/password <<EOP
exec yourproc
go
EOP


See man cron or crontab for more, and see FAQ faq822-2218
HTH
Dickie Bird (-)))