Scheduling a DTS

I have created a DTS Import routine and scheduled it to run every hour.
I started the agent but despite that, the schedule never seems to work.
I am forced to run it manually.
Any Ideas how I can get it to work ?Could it be it's still running, or has it run but failed.
In EnterPrise Manager :- Management
SQL Server Agent
Jobs
If you right click your job and 'Show History' has it ever ran..?
Also ensure Enabled = 'Yes' and Schedule = 'Yes'
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> I have created a DTS Import routine and scheduled it to run every hour.
> I started the agent but despite that, the schedule never seems to work.
> I am forced to run it manually.
> Any Ideas how I can get it to work ?
>
>|||" Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
Where do I access the Enabled and the Shedule ?
Sorry for being ignorant but I have never done this before.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> Could it be it's still running, or has it run but failed.
> In EnterPrise Manager :- Management
> SQL Server Agent
> Jobs
> If you right click your job and 'Show History' has it ever ran..?
> Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > I have created a DTS Import routine and scheduled it to run every hour.
> > I started the agent but despite that, the schedule never seems to work.
> > I am forced to run it manually.
> >
> > Any Ideas how I can get it to work ?
> >
> >
> >
>|||Whilst viewing the Jobs window, 2 of the columns are entitled Enabled,
Scheduled.
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> Where do I access the Enabled and the Shedule ?
> Sorry for being ignorant but I have never done this before.
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > Could it be it's still running, or has it run but failed.
> >
> > In EnterPrise Manager :- Management
> > SQL Server Agent
> > Jobs
> >
> > If you right click your job and 'Show History' has it ever ran..?
> >
> > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > I have created a DTS Import routine and scheduled it to run every
hour.
> > > I started the agent but despite that, the schedule never seems to
work.
> > > I am forced to run it manually.
> > >
> > > Any Ideas how I can get it to work ?
> > >
> > >
> > >
> >
> >
>|||Sorry.
I can see it now.
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> Where do I access the Enabled and the Shedule ?
> Sorry for being ignorant but I have never done this before.
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > Could it be it's still running, or has it run but failed.
> >
> > In EnterPrise Manager :- Management
> > SQL Server Agent
> > Jobs
> >
> > If you right click your job and 'Show History' has it ever ran..?
> >
> > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > I have created a DTS Import routine and scheduled it to run every
hour.
> > > I started the agent but despite that, the schedule never seems to
work.
> > > I am forced to run it manually.
> > >
> > > Any Ideas how I can get it to work ?
> > >
> > >
> > >
> >
> >
>|||No problem, if your new to the SQL Server Agent this may be of use :-
http://www.sqlpass.org/news/02feb/index.cfm?passnews=DBA1
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:ua218MUpDHA.1488@.TK2MSFTNGP12.phx.gbl...
> Sorry.
> I can see it now.
>
> "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> > " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> >
> > Where do I access the Enabled and the Shedule ?
> > Sorry for being ignorant but I have never done this before.
> >
> >
> > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > Could it be it's still running, or has it run but failed.
> > >
> > > In EnterPrise Manager :- Management
> > > SQL Server Agent
> > > Jobs
> > >
> > > If you right click your job and 'Show History' has it ever ran..?
> > >
> > > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> > >
> > > --
> > > HTH
> > > Ryan Waight, MCDBA, MCSE
> > >
> > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > > I have created a DTS Import routine and scheduled it to run every
> hour.
> > > > I started the agent but despite that, the schedule never seems to
> work.
> > > > I am forced to run it manually.
> > > >
> > > > Any Ideas how I can get it to work ?
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||None of my DTS services appear in jobs.
What am I doing wrong.
I thought that after creating a schedule event for a dts it would appear as
a job ?
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:Oz4SPMUpDHA.1672@.TK2MSFTNGP09.phx.gbl...
> Whilst viewing the Jobs window, 2 of the columns are entitled Enabled,
> Scheduled.
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> > " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> >
> > Where do I access the Enabled and the Shedule ?
> > Sorry for being ignorant but I have never done this before.
> >
> >
> > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > Could it be it's still running, or has it run but failed.
> > >
> > > In EnterPrise Manager :- Management
> > > SQL Server Agent
> > > Jobs
> > >
> > > If you right click your job and 'Show History' has it ever ran..?
> > >
> > > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> > >
> > > --
> > > HTH
> > > Ryan Waight, MCDBA, MCSE
> > >
> > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > > I have created a DTS Import routine and scheduled it to run every
> hour.
> > > > I started the agent but despite that, the schedule never seems to
> work.
> > > > I am forced to run it manually.
> > > >
> > > > Any Ideas how I can get it to work ?
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Right click on Jobs and Choose Refresh
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:e2BLOQUpDHA.3320@.tk2msftngp13.phx.gbl...
> None of my DTS services appear in jobs.
> What am I doing wrong.
> I thought that after creating a schedule event for a dts it would appear
as
> a job ?
>
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:Oz4SPMUpDHA.1672@.TK2MSFTNGP09.phx.gbl...
> > Whilst viewing the Jobs window, 2 of the columns are entitled Enabled,
> > Scheduled.
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> > > " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> > >
> > > Where do I access the Enabled and the Shedule ?
> > > Sorry for being ignorant but I have never done this before.
> > >
> > >
> > > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > > news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > > Could it be it's still running, or has it run but failed.
> > > >
> > > > In EnterPrise Manager :- Management
> > > > SQL Server Agent
> > > > Jobs
> > > >
> > > > If you right click your job and 'Show History' has it ever ran..?
> > > >
> > > > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> > > >
> > > > --
> > > > HTH
> > > > Ryan Waight, MCDBA, MCSE
> > > >
> > > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > > > I have created a DTS Import routine and scheduled it to run every
> > hour.
> > > > > I started the agent but despite that, the schedule never seems to
> > work.
> > > > > I am forced to run it manually.
> > > > >
> > > > > Any Ideas how I can get it to work ?
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thanks Ryan.
I might have learned a little but I still canr figure out how to run a DTS
from a job.
Its driving me nuts.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eL8KFPUpDHA.2488@.TK2MSFTNGP12.phx.gbl...
> No problem, if your new to the SQL Server Agent this may be of use :-
> http://www.sqlpass.org/news/02feb/index.cfm?passnews=DBA1
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> news:ua218MUpDHA.1488@.TK2MSFTNGP12.phx.gbl...
> > Sorry.
> > I can see it now.
> >
> >
> > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> > > " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> > >
> > > Where do I access the Enabled and the Shedule ?
> > > Sorry for being ignorant but I have never done this before.
> > >
> > >
> > > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > > news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > > Could it be it's still running, or has it run but failed.
> > > >
> > > > In EnterPrise Manager :- Management
> > > > SQL Server Agent
> > > > Jobs
> > > >
> > > > If you right click your job and 'Show History' has it ever ran..?
> > > >
> > > > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> > > >
> > > > --
> > > > HTH
> > > > Ryan Waight, MCDBA, MCSE
> > > >
> > > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > > > I have created a DTS Import routine and scheduled it to run every
> > hour.
> > > > > I started the agent but despite that, the schedule never seems to
> > work.
> > > > > I am forced to run it manually.
> > > > >
> > > > > Any Ideas how I can get it to work ?
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Another good resource at :- www.sqldts.com
--
HTH
Ryan Waight, MCDBA, MCSE
"Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
news:OI84bhUpDHA.2000@.TK2MSFTNGP12.phx.gbl...
> Thanks Ryan.
> I might have learned a little but I still canr figure out how to run a DTS
> from a job.
> Its driving me nuts.
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:eL8KFPUpDHA.2488@.TK2MSFTNGP12.phx.gbl...
> > No problem, if your new to the SQL Server Agent this may be of use :-
> >
> > http://www.sqlpass.org/news/02feb/index.cfm?passnews=DBA1
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > news:ua218MUpDHA.1488@.TK2MSFTNGP12.phx.gbl...
> > > Sorry.
> > > I can see it now.
> > >
> > >
> > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > news:uJdjHJUpDHA.3256@.tk2msftngp13.phx.gbl...
> > > > " Also ensure Enabled = 'Yes' and Schedule = 'Yes' "
> > > >
> > > > Where do I access the Enabled and the Shedule ?
> > > > Sorry for being ignorant but I have never done this before.
> > > >
> > > >
> > > > "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> > > > news:Oi$fOCUpDHA.2868@.TK2MSFTNGP09.phx.gbl...
> > > > > Could it be it's still running, or has it run but failed.
> > > > >
> > > > > In EnterPrise Manager :- Management
> > > > > SQL Server Agent
> > > > > Jobs
> > > > >
> > > > > If you right click your job and 'Show History' has it ever ran..?
> > > > >
> > > > > Also ensure Enabled = 'Yes' and Schedule = 'Yes'
> > > > >
> > > > > --
> > > > > HTH
> > > > > Ryan Waight, MCDBA, MCSE
> > > > >
> > > > > "Poppy" <paul.diamond@.NOSPAMthemedialounge.com> wrote in message
> > > > > news:%230hc$$TpDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > > > > I have created a DTS Import routine and scheduled it to run
every
> > > hour.
> > > > > > I started the agent but despite that, the schedule never seems
to
> > > work.
> > > > > > I am forced to run it manually.
> > > > > >
> > > > > > Any Ideas how I can get it to work ?
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>sql