scheduling dts jobs fails

Hello,
Could somebody tell me what i'm doing wrong. I have created a dts job from
the client console on my computer. Next i want to schedule the dts job, but
whenever it starts it is always failing.
Is it because i've created the dts job on my computer? I can see the owner
of the job is the name of my computer/username.
Greetings,
Zeke
I guess it has to do with security. When you schedule a job, it is executed
under different user account, not under yours. if you are a member of the
sysadmin role, then it is executed using SQL Server Agent's account.
Otherwise you can use so-called proxy account (check more in Books OnLine).
And the account used might not have permissions (maybe on file system as
well, not just SQL Server, depends on whatever the package is doing). Or it
does not see the drives you mapped using your account, etc.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ezekil" <ezekiel@.lycos.nl> wrote in message
news:%23EwqWe1MEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Could somebody tell me what i'm doing wrong. I have created a dts job from
> the client console on my computer. Next i want to schedule the dts job,
but
> whenever it starts it is always failing.
> Is it because i've created the dts job on my computer? I can see the owner
> of the job is the name of my computer/username.
> Greetings,
> Zeke
>

scheduling dts jobs fails

Hello,
Could somebody tell me what i'm doing wrong. I have created a dts job from
the client console on my computer. Next i want to schedule the dts job, but
whenever it starts it is always failing.
Is it because i've created the dts job on my computer? I can see the owner
of the job is the name of my computer/username.
Greetings,
ZekeI guess it has to do with security. When you schedule a job, it is executed
under different user account, not under yours. if you are a member of the
sysadmin role, then it is executed using SQL Server Agent's account.
Otherwise you can use so-called proxy account (check more in Books OnLine).
And the account used might not have permissions (maybe on file system as
well, not just SQL Server, depends on whatever the package is doing). Or it
does not see the drives you mapped using your account, etc.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ezekil" <ezekiel@.lycos.nl> wrote in message
news:%23EwqWe1MEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Could somebody tell me what i'm doing wrong. I have created a dts job from
> the client console on my computer. Next i want to schedule the dts job,
but
> whenever it starts it is always failing.
> Is it because i've created the dts job on my computer? I can see the owner
> of the job is the name of my computer/username.
> Greetings,
> Zeke
>

scheduling dts jobs fails

Hello,
Could somebody tell me what i'm doing wrong. I have created a dts job from
the client console on my computer. Next i want to schedule the dts job, but
whenever it starts it is always failing.
Is it because i've created the dts job on my computer? I can see the owner
of the job is the name of my computer/username.
Greetings,
ZekeI guess it has to do with security. When you schedule a job, it is executed
under different user account, not under yours. if you are a member of the
sysadmin role, then it is executed using SQL Server Agent's account.
Otherwise you can use so-called proxy account (check more in Books OnLine).
And the account used might not have permissions (maybe on file system as
well, not just SQL Server, depends on whatever the package is doing). Or it
does not see the drives you mapped using your account, etc.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Ezekiël" <ezekiel@.lycos.nl> wrote in message
news:%23EwqWe1MEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Could somebody tell me what i'm doing wrong. I have created a dts job from
> the client console on my computer. Next i want to schedule the dts job,
but
> whenever it starts it is always failing.
> Is it because i've created the dts job on my computer? I can see the owner
> of the job is the name of my computer/username.
> Greetings,
> Zeke
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nick
Create a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>
|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>

schedule backup database

Hi All:
my local computer using sql server to maintain several databases
and i back up all database munallly everyday , so just wondering any idea i
can setup schedule job to backup database automatically everyday , for
exmaple back up database everyday at 5 pm.. etc
Cheers
nickCreate a database maintenance plan. It's simple, books online can show you
how.
Tip: Create two maintenance plans -- one for user databases and the other
for system databases (master, model, msdb). In the user DB plan, backup the
transaction logs. In the system DB plan, do not backup transaction logs.
John Steen
"Nick" wrote:

> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>
>|||Watch a free flash video on creating database maintenance plans for
SQL Server.
http://www.eggheadcafe.com/videodemo/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:ufEG8xtDFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi All:
> my local computer using sql server to maintain several databases
> and i back up all database munallly everyday , so just wondering any idea
> i
> can setup schedule job to backup database automatically everyday , for
> exmaple back up database everyday at 5 pm.. etc
>
> Cheers
> nick
>