Hi, How do I run a job I created, without have to set the scheduled time all the time for testing

Can I execute the 'job' from a script?
How about a right click 'run job now'

I am trying to test, run this...nothing happens.... what's wrong

JOB "Qa Daily DB Backup"
BEGIN

EXECUTE IMMEDIATE 'BACKUP DATABASE Minfos_DB AS "' +
 REPLACE ('-' WITH '' IN (CAST(CURRENT_DATE AS VARCHAR(10)))) + ' ' +
 REPLACE (':' WITH '' IN (SUBSTRING(CAST(CURRENT_TIME AS VARCHAR(8)), 1 FOR 8))) +
 ' - ' + 'Minfos_DB' +
 '" TO STORE "QA DailyBackup" INCLUDE CATALOG';
END

Graeme,

are you running EDB in local or C/S mode? As far as I know it works only
in C/S mode.

Regards Uli

C\S mode v2.02 b1

Now Running ok in the manager... Looked in log file... seems it did not run last night?





Uli Becker <test@test.com> wrote:

Graeme,

are you running EDB in local or C/S mode? As far as I know it works only
in C/S mode.

Regards Uli

Graeme,

<< Hi, How do I run a job I created, without have to set the scheduled time
all the time for testing

Can I execute the 'job' from a script?
How about a right click 'run job now' >>

It's on the list for 2.03.  I was just going through these enhancements to
the EDB Manager this morning, and this one is a definite for inclusion.

For now you'll have to copy and paste the job definition into a script
window.

--
Tim Young
Elevate Software
www.elevatesoft.com