Home » Infrastructure » Windows » Scheduled Tasks for export table (oracle form 6i ,database 9i,windows 2003 server)
Scheduled Tasks for export table [message #507601] Tue, 17 May 2011 05:31 Go to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
i have batch file name exptab,to export all table in database
for example
@echo off
exp scott/tigger tables=emp file=C:\imp\emp.dmp LOG =C:\imp\log1
batch file working fine when i click on it,
my propblem i need to use the Scheduled Tasks in windows 2003 so when the computer startup batch file will run automatically i follow all the step but its not working i try the same story with windows xp still problem exist
can any one help please
Re: Scheduled Tasks for export table [message #507603 is a reply to message #507601] Tue, 17 May 2011 05:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
i follow all the step but its not working

If only we knew which steps you followed (and what happened once you finished - any error? Which one?) ...
Re: Scheduled Tasks for export table [message #507607 is a reply to message #507603] Tue, 17 May 2011 06:36 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
oracle form 6i


How does it relate to Forms 6i ?

schtasks /Create /RU <Username> /RP <User password > /SC ONSTART /TN <Taskname> /TR <your batch file>
IS a genaral syntax.
http://ss64.com/nt/schtasks.html

sriram

Re: Scheduled Tasks for export table [message #507833 is a reply to message #507603] Wed, 18 May 2011 03:40 Go to previous messageGo to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
this is the error in sqlnet
  • Attachment: sqlnet.log
    (Size: 112.72KB, Downloaded 1679 times)
Re: Scheduled Tasks for export table [message #507844 is a reply to message #507603] Wed, 18 May 2011 03:59 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens when you MANUALLY run that job from Windows Task Scheduler? What is its status?
Re: Scheduled Tasks for export table [message #507880 is a reply to message #507844] Wed, 18 May 2011 06:40 Go to previous messageGo to next message
hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates
Senior Member
it run successfully
Re: Scheduled Tasks for export table [message #507887 is a reply to message #507880] Wed, 18 May 2011 06:54 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's strange. You can run that batch file manually, you can run it manually from Task Scheduler, but it won't run on startup.

What happens if you, as a command, use something like this:
%windir%\system32\cmd.exe /C your_export_batch_file.bat
Previous Topic: ORA-12500... (Oracle Service does not start Access denied Error 5) (2 threads merged by bb)
Next Topic: JREW.EXE has stopped working
Goto Forum:
  


Current Time: Thu Mar 28 18:36:00 CDT 2024