Archives of the TeradataForum

Message Posted: Mon, 03 Apr 2006 @ 15:37:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi there,

I've got one drive device to use for backups. Since I back up my data and DBC tables separately I run two jobs. Currently these are done manually, one after the other.

I would like to schedule the second job to run automatically once the first job has finished using the Trigger facility of Netvault.

I cannot seem to find sufficient documentation to do this.

I've created the first job with normal scheduling and placed the following command in its post script:

     /var/opt/netvault6/util/nvtrigger -server smp001-4 test_trigger

In the 2nd job under the scheduling window, I've selected Trigger and given the trigger the name test_trigger.

The script of test_trigger is:

     arcmain << EOF
     LOGON $LOGON;
     ARCHIVE DATA TABLES (PROD_LOC_TMP)
     ,RELEASE LOCK
     ,OUTPUT ROW COUNT
     ,FILE = XXX;
     LOGOFF;
     EOF

When the command in post script runs, I get the following message:

No jobs started by trigger: 'test_trigger'

Any ideas?

Thanks,

Chaim

	<Prev	Next>		<<First	<Prev	Next>	Last>>