The scheduler tag has no wiki summary.
0
votes
0answers
27 views
Passing parameters to a procedure executed by DBMS_SCHEDULER
I have a scheduler program that runs a stored procedure that requires input parameters.
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM
(program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING');
END;
...
0
votes
0answers
41 views
Mysql scheduler is not running
I have create few events in my db. One is to daily create partition. Another is to summarize data on every second from another table. I notice everything is not running. What would have cause the ...
1
vote
1answer
101 views
Force chain to start immediately after completion instead of on a timer
Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...
0
votes
1answer
28 views
Oracle scheduler max_jobs_Slave_processes is set to null, how many will be allocated?
Executing the following query against my database:
select value
from dba_scheduler_global_attribute
where attribute_name='MAX_JOB_SLAVE_PROCESSES';
yields a value of NULL. My question is what ...
0
votes
1answer
29 views
Oracle scheduler chain priority in data warehouse applications
The scenario is as follows:
We have a data warehouse type application that relies on the Oracle job scheduler and a Chain. This chain is responsible for generating materialized views (caches) that ...
1
vote
0answers
62 views
Pass in dynamic value to Oracle job scheduler
How does one pass a dynamic value into the oracle job scheduler when the underlying command is a stored procedure?
example procedure:
create procedure foo (bar varchar2)
...
Job creation in ...
0
votes
0answers
62 views
can I update a view using Oracle scheduler?
I have a view and some UIs displaying this view. The UIs should check for updates of that view periodically. I want Oracle database to trigger this event. Can I use Oracle scheduler for this? And How?
...
1
vote
2answers
254 views
Scheduled backup errors
I am trying to do the following. I have about 50 DBs and a network NAS that acts as backup machine. I have made an sql script(lets say backup.sql) with 50 lines each of these say "BACKUP DATABASE ABC ...
9
votes
3answers
20k views
Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
I am tasked with devising a maintenance plan for our Sql Server 2005 databases. I know for backups I want to do a daily full database backup and transactional log backups every 15 minutes. My problem ...
15
votes
4answers
7k views
Task scheduler for SQL Server Express
I have an ASP.NET MVC app which works with database under SQL Server 2008 R2 Express edition. There is a need to perform a regular task on updating some records in the database.
Unfortunately the ...
