Database Design

automated database script

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2009

Posts: 13

Reputation: jbd4d is an unknown quantity at this point

Solved Threads: 0

jbd4d

Offline

Newbie Poster

automated database script

Jul 28th, 2009

Im not sure if this is the proper place to be posting this but...
I have a dedicated server that i would like to automatically run a script every 10 minutes/ half hour / any set period of time. I do not want to have to leave my personal computer running/ have a web page open. I was wondering if its possible to have my server run a "script" on its own every [set period of time].

•

Join Date: Sep 2008

Posts: 118

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Re: automated database script

Jul 28th, 2009

Schedule a job to run the script at whatever interval you want.

•

Join Date: Jul 2009

Posts: 13

Reputation: jbd4d is an unknown quantity at this point

Solved Threads: 0

jbd4d

Offline

Newbie Poster

Re: automated database script

Jul 28th, 2009

i read that mysql can do an event scheduler, does that run even if the file isn't open? If not is there a way to make it?

•

Join Date: Sep 2008

Posts: 118

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Re: automated database script

Jul 28th, 2009

I don't know mysql very much but if you schedule a job it should not care if a file is open or not.

•

Join Date: Jul 2009

Posts: 13

Reputation: jbd4d is an unknown quantity at this point

Solved Threads: 0

jbd4d

Offline

Newbie Poster

Re: automated database script

Jul 29th, 2009

is this the kind of thing youre talking about? I don't really know much about servers or what job scheduling is, but this seems to be what youre talking about, let me know if this is completely off-base:

"
DBMS_JOB does this exactly.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT TEXT
  FROM all_source
 WHERE name = 'DBMS_JOB'
   AND type = 'PACKAGE'
 ORDER BY line;
select text
  from all_source
 where name = 'DBMS_JOB'
   and type = 'PACKAGE'
 order by line;

In your case, it is very easy:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
DECLARE
   l_job number;
BEGIN
   dbms_job.submit( l_job,
                   'abc;',
                    trunc(SYSDATE)+4/24,
                   'trunc(sysdate)+1+4/24' );
END;
declare
   l_job number;
begin
   dbms_job.submit( l_job,
                   'abc;',
                    trunc(sysdate)+4/24,
                   'trunc(sysdate)+1+4/24' );
end;

Last edited by peter_budo; Jul 30th, 2009 at 8:15 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Sep 2008

Posts: 118

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Re: automated database script

Jul 29th, 2009

Here is a link to an article on creating an event schedule in mysql, unfortunately I don't use mysql so it is the best I can do for you.

http://dev.mysql.com/tech-resources/...t-feature.html

If this doesn't work possibly you can use windows task scheduler to call the job.