dbTalk Databases Forums  

Re: Scheduling a monthly dts job.

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


Discuss Re: Scheduling a monthly dts job. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Scheduling a monthly dts job. - 01-07-2004 , 07:32 AM






And what does happen ?
Errors?
Job Enabled?
Schedule Enabled?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ricardo Flores" <anonymous (AT) discussions (DOT) microsoft.com> wrote

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

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

down below : i have clicked : occurrs only once at:

"03:00:00 am".

however, the job will not run through the scheduler.

Please help

thank you.



Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: Scheduling a monthly dts job. - 01-07-2004 , 12:46 PM







And what does happen ? nothing
Errors? no errors
Job Enabled? job is enabled
Schedule Enabled? the scheduler is enabled. All my daily
jobs run every day.



Quote:
-----Original Message-----
And what does happen ?
Errors?
Job Enabled?
Schedule Enabled?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ricardo Flores" <anonymous (AT) discussions (DOT) microsoft.com
wrote in message
news:0a1901c3d521$6f104480$a401280a (AT) phx (DOT) gbl...
I am trying to schedule a dts job with the following
parameters on the job schedule:

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

down below : i have clicked : occurrs only once at:

"03:00:00 am".

however, the job will not run through the scheduler.

Please help

thank you.


.


Reply With Quote
  #3  
Old   
floresr@miamidade.gov
 
Posts: n/a

Default Re: Scheduling a monthly dts job. - 01-07-2004 , 12:49 PM



Quote:
And what does happen ? Nothing happens
Errors? no errors
Job Enabled? yes
Schedule Enabled? yes. All my daily jobs run every day.
-----Original Message-----
And what does happen ?
Errors?
Job Enabled?
Schedule Enabled?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ricardo Flores" <anonymous (AT) discussions (DOT) microsoft.com
wrote in message
news:0a1901c3d521$6f104480$a401280a (AT) phx (DOT) gbl...
I am trying to schedule a dts job with the following
parameters on the job schedule:

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

down below : i have clicked : occurrs only once at:

"03:00:00 am".

however, the job will not run through the scheduler.

Please help

thank you.


.


Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Scheduling a monthly dts job. - 01-08-2004 , 01:46 AM



Does a non dts job work ?
What does the history for the job say ?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"floresr (AT) miamidade (DOT) gov" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:08e601c3d54f$08834860$a001280a (AT) phx (DOT) gbl...
Quote:
And what does happen ? Nothing happens
Errors? no errors
Job Enabled? yes
Schedule Enabled? yes. All my daily jobs run every day.
-----Original Message-----
And what does happen ?
Errors?
Job Enabled?
Schedule Enabled?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ricardo Flores" <anonymous (AT) discussions (DOT) microsoft.com
wrote in message
news:0a1901c3d521$6f104480$a401280a (AT) phx (DOT) gbl...
I am trying to schedule a dts job with the following
parameters on the job schedule:

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

down below : i have clicked : occurrs only once at:

"03:00:00 am".

however, the job will not run through the scheduler.

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.