0

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

2
Contributors
6
Replies
7
Views
8 Years
Discussion Span
Last Post by jbd4d
0

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?

0

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

0

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.

select text
  from all_source
 where name = 'DBMS_JOB'
   and type = 'PACKAGE'
 order by line;

In your case, it is very easy:

declare
   l_job number;
begin
   dbms_job.submit( l_job,
                   'abc;',
                    trunc(sysdate)+4/24,
                   'trunc(sysdate)+1+4/24' );
end;

"

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.