Hector
08 de Febrero del 2006

¿Como hago para saber el numero de un job?
Si pongo esto:
select * from user_jobs;
me sale:

JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DAT LAST_SEC THIS_DAT THIS_SEC NEXT_DAT NEXT_SEC TOTAL_TIME B INTERVAL FAILURES
---------- ------------------------------ ------------------------------ ------------------------------ -------- -------- -------- -------- -------- -------- ---------- - -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------
WHAT

NLS_ENV

MISC_ENV INSTANCE
---------------------------------------------------------------- ----------
1 SYS SYS SYS 08/02/06 11:31:39 09/02/06 00:00:00 1 N TRUNC(SYSDATE+1,\'DD\') 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

3 SYS SYS SYS 08/02/06 11:31:40 08/02/06 13:55:40 0 N SYSDATE+0.1 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

4 SYS SYS SYS 08/02/06 12:28:10 08/02/06 12:28:30 0 N SYSDATE+1/(24*60*3) 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

5 SYS SYS SYS 08/02/06 12:28:10 08/02/06 12:28:30 3 N SYSDATE+1/(24*60*3) 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

6 SYS SYS SYS 08/02/06 12:28:10 08/02/06 12:28:30 4 N SYSDATE+1/(24*60*3) 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

7 SYS SYS SYS 08/02/06 12:28:10 08/02/06 12:28:30 0 N SYSDATE+1/(24*60*3) 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0

8 SYS SYS SYS 08/02/06 12:28:25 08/02/06 12:28:26 6 N SYSDATE+1/(24*60*60) 0
begin hacer_job; end;
NLS_LANGUAGE=\'SPANISH\' NLS_TERRITORY=\'SPAIN\' NLS_CURRENCY=\'€\' NLS_ISO_CURRENCY=\'SPAIN\' NLS_NUMERIC_CHARACTERS=\',.\' NLS_DATE_FORMAT=\'DD/MM/RR\' NLS_DATE_LANGUAGE=\'SPANISH\' NLS_SORT=\'SPANISH\'
0102000202000000 0


7 filas seleccionadas.


¿Cual es el numero del job?

Muchas gracias.

a
08 de Febrero del 2006

job

Hector
08 de Febrero del 2006

Si ejecutas job directamente no compila ni nada. ¿Alguna otra ayudica?
Gracias

a
08 de Febrero del 2006

tu preguntabas por el número del job y te he dicho que es la columna con nombre "job"