CAN DBMS_SCHEDULER IN 10G ALTER JOB'S NEXT EXECUTION TIME AS DBMS_JOB?

Ihave a scheduled job create and monitor using DBMS_JOB package in 8i.
After upgrade to 10g, we recognize
there is a new package DBMS_Scheduler which superseded DBMS_JOB and it
is
easier to moniter and manage through the EM.

However, I know that there is a procedure NEXT_DATE in DBMS_JOB which
alter job's next execution time but I can't find any similar function
in DBMS_Scheduler. The Set_Attribute function only allows update of
"start_date" or "end_date" but not the next run date.

Any one knows how to change the next run time but doesn't affect the
original scheduling? such that after running at the changed "next run
time", it can retain the next run as the original interval defined.

Thanks and Regards,
Cherry

.

Relevant Pages

  • Re: CAN DBMS_SCHEDULER IN 10G ALTER JOBS NEXT EXECUTION TIME AS DBMS_JOB?
    ... After upgrade to 10g, we recognize ... there is a new package DBMS_Scheduler which superseded DBMS_JOB and it ... easier to moniter and manage through the EM. ...
    (comp.databases.oracle.server)
  • Re: DTS issue on SQL 2k
    ... When the DTS package runs as a scheduled job, it is not running as you. ... Either the SQL Server service account or the SQL Agent Proxy account is ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled Job Fails, But Runs Successfully Interactively
    ... Andrew J. Kelly SQL MVP "CR" wrote in message ... >I have a package with a data pump task that uses an alias set up in the>Client Network Utility to a remote server. ... However, when I run this>very same package as a scheduled job, it fails on the step that utilizes>the alias:> ... > Step Error Help Context ID:0 ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Hanged When Scheduled
    ... The DTS element finishes and the data loads, ... I have set the "Execute on main package thread" as the paper recommends, ... Microsoft Online Support ... | responding when you run it as a SQL Server Agent scheduled job. ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduling a package?
    ... This will cause you problems when scheduling and you have sensitive info in the package. ... The problem I have is that I can't get a scheduled job to run it. ...
    (microsoft.public.sqlserver.dts)
Loading