May 22, 2003 at 11:36 am
I have a schedule for a job, which supposes to run the job once an hour. But sometime the job stop somewhere and never start again, sometimes it stack at some step of the job and never stop. In both cases there no error message generated. I find it out because the job was not done by schedule.
Need help.
Thanks
May 22, 2003 at 12:34 pm
Was job created by maintenance wizard?
May 22, 2003 at 12:42 pm
No.
One is a merge agent,another one is created by myself for sending data to a ftp site, it uncategorized.
thanks.
May 22, 2003 at 9:03 pm
Run one step at a time to find out which step are causing the problem and post the script/SP of that step here see whether we could help out.
May 23, 2003 at 7:29 am
Here is a example:
Step 1: run a DTS job: DTSRun /~Z0xEEE636F80548F73BA5EF00A188020419240846A5997A9C43D83FB3FFFB45BD53333A443666903946F30BA9567E487415C37678474BFDEB13786E3197438AF920742AA740327BBF834A7244374B5F0B900DBE91
Step 2: run a script:
set nocount on
create table #ftp_script (
script_line varchar(255) not null )
insert #ftp_script values ( 'name' )
insert #ftp_script values ( 'pwdstring' )
insert #ftp_script values ( 'ascii' )
insert #ftp_script values ( 'append C:\temp\Data1 remotePath\Data1.dat' )
insert #ftp_script values ( 'append C:\temp\Date2 remotePath\Data2.dat' )
insert #ftp_script values ( 'quit' )
exec Vineftp // a store procedure
'#ftp_script',
'script_line',
'ftp.vine.appriss.com'
drop table #ftp_script
It supposes to run once an hour, most times is ok. The last run status is 5/20/2003 2:00 pm Succeeded, the status says Excuting job step 2, it is still there.
Edited by - lxwang on 06/02/2003 10:34:34 AM
Edited by - lxwang on 06/02/2003 10:38:49 AM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply