Scheduling Task(running .bat file) on Windows 2000

Hi,
    I have a question regarding scheduling Task in a windows 2000 environment.
I have a .bat file wich does Oracle DB export to a .dmp file.
I want to task such that that batch file is run every 6 hours. This .bat file outputs as .dmp, say export.dmp
I want to schedule that in such a way that the exported file was post-fixed with some datetime in order to avoid from overwriting the .dmp file everytime it is run. How do I do that?
Thanks,
Kishore
kingno1Asked:
Who is Participating?
 
SysExpertCommented:
The easiest way is to rename the old file based beforehand, or rename the new file immediately after the export.

You can use the following as a template to get hold of the date-time info.
Use the tempdir to be part of the filename in the
ren command.

-----------

From: czpczp    Date: 06/25/2001 12:59PM PST Time date in batch file name directory by date
     The following script does *exactly* what you're looking for.  It will use the Time command
   (not time/t 'cause it doesn't give the seconds which is what you want), and parses the output string
 to extract the time in reverse order SEC:MIN:HR *extracting* the semi-colons.  THEN, it creates a directory
     *including* the client's name.  I did extensively test the script using varying times without having
      any problems.


     Cut and paste (verbatim) the script below into file with a BAT extension.  The following creates the
       directory on the root of the current drive (last line) -- you can alter where the directory is created
        depending on your needs (i.e. Md F:\LOG\%UserName%_%DirTemp%).

 Rem  ~~~ MakeDir.Bat ~~~~~~~~~~~~~~~~~~~~~~~~~~~

                 @echo off
                 cls

                 REM ** the following line gets the current time into a variable
                 echo.|time >holdstr

     REM ** The following 5 For statements parse the holdstr var to extract the time in reverser order
                 for /f "eol=E tokens=1,2,3*" %%a IN (holdstr) do echo %%a%%b%%c%%d  >holdstr
                 for /f "tokens=1,2* delims= " %%a IN (holdstr) do echo %%b  >holdstr
                 for /f "tokens=1,2* delims=." %%a IN (holdstr) do echo %%a  >holdstr
                 for /f "tokens=1,2,3 delims=:" %%a IN (holdstr) do echo %%c%%b%%a  >holdstr
                 for /f "tokens=1,2* delims= " %%a IN (holdstr) do set DirTemp=%%a%%b

                 REM ** remove temp file
                 del holdstr

                 Md \%UserName%_%DirTemp%

      Rem  ~~~~~~~~~MakeDir.bat

I hope this helps !

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.