dbTalk Databases Forums  

Monthly DTS Job does not start

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Monthly DTS Job does not start in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
floresr@miamidade.gov
 
Posts: n/a

Default Monthly DTS Job does not start - 01-07-2004 , 04:06 PM






I am trying to schedule a monthly dts job with the
following parameters on the job scheduler:

"monthly", day "1" of every "1" month

down below : i clicked : occurs only once at:

"03:00:00 am".

however, the job does not start at the time defined.

(the job is enabled, sqlagent is started, the scheduler
is enabled).
Don't know what is going on.

Please help

thank you.


Reply With Quote
  #2  
Old   
Invotion
 
Posts: n/a

Default Monthly DTS Job does not start - 01-07-2004 , 05:56 PM






What database user is the job set to run as?
My hunch is that is where your problem lies. Have you
checked the job history?

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com


Quote:
-----Original Message-----
I am trying to schedule a monthly dts job with the
following parameters on the job scheduler:

"monthly", day "1" of every "1" month

down below : i clicked : occurs only once at:

"03:00:00 am".

however, the job does not start at the time defined.

(the job is enabled, sqlagent is started, the
scheduler
is enabled).
Don't know what is going on.

Please help

thank you.

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.