Recent content by joeythelips

Hi I am trying to add a cronjob which will zip log files at the end of the day. I have added the following command 15 00 * * 0-6 find /opt/gtx/common/logs/testcompress -mtime +1 -exec gzip -f {} \; I can't seem to get it to work, has anyone any suggestions?

sorry asbout that

Start Your Own Group on Tek-Tips! Click Here! My Threadminder Activity since last visit Remove forum(s) from list MIS/IT Lotus/IBM: Notes Microsoft: Office Andrew Tridgell: Samba -General UNIX discussion HP: HP-UX Microsoft: Internet Information Server Programmers Microsoft SQL Server...

I am try to creata a sequence starting with a value from another table CREATE SEQUENCE CALL_PRODUCT_SEQ START WITH (SELECT CURR_VALUE FROM snap_counter where name ='AIB_CALL_PRODUCT_SEQ') INCREMENT BY 1 however it won't allow it, I have also tried to create the sequence starting with 1 and...

here's the code! CREATE PROCEDURE USP_DATABASE_SIZES AS -- DECLARES DECLARE @DBNAME VARCHAR(40) DECLARE @STRING VARCHAR(300) -- STORES EACH DATABASE NAME IN A TEMP TABLE CREATE TABLE #DATABASE_NAMES ( DBNAME VARCHAR (50) ) INSERT INTO #DATABASE_NAMES SELECT NAME FROM...

Hi, i am running the following script on my HP-UX server connect / as sysdba spool /u01/backup/ROIMOP/logs/recoverstdby.log startup nomount alter database mount standby database; alter database recover automatic standby database; shutdown immediate; spool off exit , but keep getting the message...

Hi, I have a query which i imagine is pretty easy to do but i need the help of someone: i have a script file whcih contains references to directories eg /u01/backup/ISCUST/ftpfiles.sh I want to change the script using vi to /u01/backup/ROIMOP/ftpfiles.sh How can i change the word ISCUST to...

Hi, i am trying to copy a db from one server to another using the copy database wizard. No matter what options i select, the job keeps failing with the following error message: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Unspecified error...

hi. i have the job setup now to be run as sa. on another note, what are the implications/advantages of having full recovery mode versus simple?

also, the recovery mode is simple!

Hi, thanks for your help. i checked the job history and got the following: The job failed. The owner () of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' does not have server access. How do i check who the job runs as? I take it it is run by the user who my sql server...

thanks ken. looks like import/export is my best option? alex, i think transportable tablespaces are available in 8i. how would that work then?

alex, thanks for your help. unfortunately i don't think this would cover my needs as 1, i have a couple of tables with long datatypes. 2, i would also need to recreate some constraints. Joe

hi ken, that was kind of what i was thinking of, but would i not overwrite the entire database with that approach? i just want to 'refresh' one schema? Joe

Hi, i have a database maintenance plan which i cannot get to work. I back up master, model, msdb and one user database as part of the plan. I have none of the optimisations or integrity options checked. I back up the data files and transaction logs at the same time. However, the plan fails...