Its giving an error saying keyword not found line 5 Dim( dir_name, string, "F:\\MLS\\site\\db\\backup\\@T"mm-dd-yyyy"" ) Dim( count, number ) Dim( do_not_create, boolean ) DirExists( dir_name, do_not_create ) IfThen( do_not_create, COPY_FILE ) DirCreate( dir_name ) COPY_FILE: FileCopyEx( "F:\\MLS\\site\\db\\*.mdb", dir_name, count ) : FileCopyEx requires 3 parameters. : Dim( dir_name, string, : "F:\\MLS\\site\\db\\backup\\@T"mm-dd-yyyy"" ) : Dim( count, number ) : DirCreate( dir_name ) : FileCopyEx( "F:\\MLS\\site\\db\\mls_db.mdb", dir_name, count ) : It is also also a good idea to have the job check for existance of the : destination directory and create it only if it does not exist. This would : allow to re-run be re-run without errors. Here is an example: Dim( : dir_name, string, : "F:\\MLS\\site\\db\\backup\\@T"mm-dd-yyyy"" ) : Dim( count, number ) : Dim( do_not_create, boolean ) : DirExists( dir_name, do_not_create ) : IfThen( do_not_create, COPY_FILE ) : DirCreate( dir_name ) : COPY_FILE: FileCopyEx( "F:\\MLS\\site\\db\\mls_db.mdb", dir_name, : count )
|