FilesExpand file tree

master

/

SWEEP_EVERNOTE_FOLDER.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

21 lines (18 loc) · 1.12 KB

master

/

SWEEP_EVERNOTE_FOLDER.sql

Copy path

Top

File metadata and controls

• Code
• Blame

21 lines (18 loc) · 1.12 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

/* Formatted on 15/01/2014 12:46:16 (QP5 v5.163.1008.3004) PANDAS Copyright (c) 2013 -Davide Moraschi (davidem@eurostrategy.net)

Todos los derechos reservados. Prohibida su reproducción Total o Parcial. */

SET DEFINE OFF

BEGIN

DBMS_SCHEDULER.DROP_JOB (job_name => 'SWEEP_UPLOAD_FOLDER_P001');

END;

ALTER SESSION SET TIME_ZONE = 'Europe/Madrid';

BEGIN

DBMS_SCHEDULER.create_job (job_name => 'SWEEP_UPLOAD_FOLDER_P001'

,job_type => 'PLSQL_BLOCK'

-- ,job_action => 'BEGIN p_flip_from_rss (p_rss_url => ''http://news.google.es/news/feeds?cf=all&ned=es&hl=es&topic=m&output=rss'', p_user => ''ProyectoPANDAS'', p_pass => ''PANDAS'', p_target_magazine =>''flipboard/mag-M4sfaY1mTfWWyp4EpnhHNQ%3Am%3A120774391-123011160''); END;'

,job_action => 'BEGIN P_SWEEP_UPLOAD_FOLDER; END;'

,start_date => CURRENT_TIMESTAMP /*hay que hacerlo así por el tema del cambio de hora en verano*/

,repeat_interval => 'freq=hourly; interval=1'

,end_date => NULL

,enabled => TRUE

,comments => 'Mueve todos los ficheros de la carpeta UPLOAD al FTP');

END;