Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept
.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)|||Thanks Wayne Spot on
"Wayne Snyder" wrote:

> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQ
L
> Agent uses... Make sure the SQL Agent login has the appropriate permission
s
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> concept.
> me
>
>sql

Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)|||Thanks Wayne Spot on
"Wayne Snyder" wrote:
> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQL
> Agent uses... Make sure the SQL Agent login has the appropriate permissions
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> > In Data Transformation Service, Local Packages,
> > I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> > created a simple DTS Package to pull one of the tables and prove the
> concept.
> > It is set
> > up so it drops the existing table, creates it again and then copies
> > the data across. It runs well when I run it as a package, however it
> > fails when I run it as a scheduled job.
> > It seems to drop the table, it then creates the table (this somehow tells
> me
> > that I
> > don't have a permissions problem because the table structure has to be
> > read from the SAGE database), but finally fails to copy the data.
> >
> > Error
> > Step Error Description:The driver returned invalid (or failed to return)
> > SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> > (80004005): Cannot find all files in data path)
>
>

Scheduling Tasks

In Data Transformation Service, Local Packages,
I need to pull data from a SAGE Line 50 v9 database into SQL . I have
created a simple DTS Package to pull one of the tables and prove the concept.
It is set
up so it drops the existing table, creates it again and then copies
the data across. It runs well when I run it as a package, however it
fails when I run it as a scheduled job.
It seems to drop the table, it then creates the table (this somehow tells me
that I
don't have a permissions problem because the table structure has to be
read from the SAGE database), but finally fails to copy the data.
Error
Step Error Description:The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
(80004005): Cannot find all files in data path)
When you run a package interactively, it runs under YOUR permissions. When
you schedule a package it runs under the permissions for the login that SQL
Agent uses... Make sure the SQL Agent login has the appropriate permissions
everywhere
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> In Data Transformation Service, Local Packages,
> I need to pull data from a SAGE Line 50 v9 database into SQL . I have
> created a simple DTS Package to pull one of the tables and prove the
concept.
> It is set
> up so it drops the existing table, creates it again and then copies
> the data across. It runs well when I run it as a package, however it
> fails when I run it as a scheduled job.
> It seems to drop the table, it then creates the table (this somehow tells
me
> that I
> don't have a permissions problem because the table structure has to be
> read from the SAGE database), but finally fails to copy the data.
> Error
> Step Error Description:The driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: 2.00 (Microsoft OLE DB Provider for ODBC Drivers
> (80004005): Cannot find all files in data path)
|||Thanks Wayne Spot on
"Wayne Snyder" wrote:

> When you run a package interactively, it runs under YOUR permissions. When
> you schedule a package it runs under the permissions for the login that SQL
> Agent uses... Make sure the SQL Agent login has the appropriate permissions
> everywhere
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "GEmsley" <GEmsley@.discussions.microsoft.com> wrote in message
> news:56B83EDA-653F-4E3F-83FA-179A645F4824@.microsoft.com...
> concept.
> me
>
>

Scheduled Tasks on Windows 2000/2003

I'm trying to use scheduled tasks to copy over transaction logs from one server to another.

Can I schedule a task to run hourly? I have it set to repeat the task every hour, but it's not working. It does it once and then the next run date is tomorrow.

Please let me know if I'm missing something.

Thanks

Susan

Figured it out..

I had the repeat task selected, but had the duration at an hour and a half.

Once I modified the duration to 24 hours it worked great!!

Thanks

Susan

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?
can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?
|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:

> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup file
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
>
>

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:

> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup fil
e
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
>
>

Scheduled Tasks for SQL 7.0

Is there a way to schedule a task to shutdown SQL server, run a backup and
restart the service after the backup is finished?can use the AT scheduler for this but why not backup the database and then
schedule the backup software using sqlserveragent to backup the backup file
as a subsequent step to the database backup?
"Margo" <margo@.discussions.microsoft.com> wrote in message
news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> Is there a way to schedule a task to shutdown SQL server, run a backup and
> restart the service after the backup is finished?|||Is there any documentation on this procedure that I could follow?
"Olu Adedeji" wrote:
> can use the AT scheduler for this but why not backup the database and then
> schedule the backup software using sqlserveragent to backup the backup file
> as a subsequent step to the database backup?
> "Margo" <margo@.discussions.microsoft.com> wrote in message
> news:1D7E947F-0F07-4DAC-84E9-C94829930DCD@.microsoft.com...
> > Is there a way to schedule a task to shutdown SQL server, run a backup and
> > restart the service after the backup is finished?
>
>

Scheduled tasks

Is it possible to schedule tasks in SQL Express, for example a database backup, or to periodically execute a stored procedure?

hi Allan,

yes, it is possible, but not using the SQL Server Agent as SQLExpress does not provide the relative bits.. you have so to rely on the native OS scheduler, third party (or self written alternative) scheduler, or rely on the Service Broker features..

personally I usually go for the native OS scheduler, where you can define a list of xx.sql scripts to be executed by a xx.cmd file.. then the xx.cmd file, connecting to SqlCMD.exe and executing each defined xx.sql script, has to be scheduled... quiete simple and not expensive... results are output to a text file similar to:

[cmdfile.cmd]

ECHO. >>Backing up databases

SqlCmd -E -S(Local)\InstanceName -i"c:\somefolder\ScheduledBackup.sql" >c:\SomeFolder\ScheduledBackupLog.txt

ECHO. >>Sending results via mail to aministrators

SqlCmd-E -S(Local) -Q"SET NOCOUNT ON; SELECT 'Mailing log of - ' + CONVERT(varchar, GETDATE());" >E:\e-VbHot\Files\Log\MailingLogBCKschedulato.txt
SqlCmd -E -S(Local)\InstanceName -Q"SET NOCOUNT ON; DECLARE @.ret int;EXEC @.ret = [applicationDB].[dbo].[amSMTPmail] @.Server = N'smtp server name', @.Sender = N'scheduledbackup@.my_company.com', @.AddressesTO = N'admin_name@.my_company.com', @.AddressesCC = N'me@.me.com', @.AddressesCCN = NULL, @.AttachFiles = N'c:\SomeFolder\ScheduledBackupLog.txt', @.Subject = N'Backup performed', @.MessageBody = N'Backup performed', @.UserName = NULL, @.UserPassword = NULL; SELECT @.ret AS [Execution result];" >>c:\SomeFolder\MailingLog.txt

[/cmdfile.cmd]

as you can see, I do personally even send the c:\SomeFolder\ScheduledBackupLog.txt resulting file via e-mail to a "list" of addresses.. this is performed via a (free) CLR stored procedure of mine, amDBObj, where the .Net code implements a poor's man SMTP mail feature to "replace" (ok... it is not comparable with) Database Mail missing feature of SQLExpress..

regards

|||

Thanks for the info Andrea. I will look into it.

Thanks, too, for the offer of the CLR email proc - but I already did one myself :)

sql

Scheduled job fails when old db's offline

I have a SQL Server 2000 db, that has db's unrelated to an application that
I run some sql server scheduled tasks. I decided I wanted to dump these old
db's, so the first step is to take the db's offline for a week before
deleting them. Well for some reason all tasks for an unrelated (?) system
would fail and until I brought these unconnected db's back online they
wouldn't run.
If I went into dts and run the apps they run fine, the Id is my elevated
domain admin account. The sql server agent that runs the task is a domain
account with local admin privileges.
Is there something I can check for to try and get more info? Nothing in the
sql logs, in the Event logs this is all I get. Stumped?
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 10/9/2007
Time: 11:02:10 AM
User: N/A
Computer: some_SQL
Description:
SQL Server Scheduled Job 'Extract_Command_Center_Meters'
(0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by User
some_domain\some_admin. The last step to run was step 1
(Extract_Command_Center_Meters 2).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.SQL Agent itself doesn't care about what dbs are on or offline. But the job
obviously does so I would start there. Look in the DTS package to see where
it references these databases. You can also try looking at the job step
itself in the job history. You will need to expand the history listing to
see the individual steps.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>I have a SQL Server 2000 db, that has db's unrelated to an application that
>I run some sql server scheduled tasks. I decided I wanted to dump these
>old db's, so the first step is to take the db's offline for a week before
>deleting them. Well for some reason all tasks for an unrelated (?) system
>would fail and until I brought these unconnected db's back online they
>wouldn't run.
> If I went into dts and run the apps they run fine, the Id is my elevated
> domain admin account. The sql server agent that runs the task is a domain
> account with local admin privileges.
> Is there something I can check for to try and get more info? Nothing in
> the sql logs, in the Event logs this is all I get. Stumped?
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 10/9/2007
> Time: 11:02:10 AM
> User: N/A
> Computer: some_SQL
> Description:
> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
> User some_domain\some_admin. The last step to run was step 1
> (Extract_Command_Center_Meters 2).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Done that already. Dang... I just am truly stumped.
As you notice it will run if done directly from the DTS editor.
--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
> SQL Agent itself doesn't care about what dbs are on or offline. But the
> job obviously does so I would start there. Look in the DTS package to see
> where it references these databases. You can also try looking at the job
> step itself in the job history. You will need to expand the history
> listing to see the individual steps.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated (?)
>>system would fail and until I brought these unconnected db's back online
>>they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>|||I had have the very same problem with a customer, they disabled the user
account which was the owner of the job and they were getting exactly the
same error...
--
Ekrem Önsoy
"Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
news:Oq9f%23fqCIHA.4752@.TK2MSFTNGP04.phx.gbl...
> Done that already. Dang... I just am truly stumped.
> As you notice it will run if done directly from the DTS editor.
> --
> Paul Bergson
> MVP - Directory Services
> MCT, MCSE, MCSA, Security+, BS CSci
> 2003, 2000 (Early Achiever), NT
> http://www.pbbergs.com
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23VSwWdpCIHA.464@.TK2MSFTNGP02.phx.gbl...
>> SQL Agent itself doesn't care about what dbs are on or offline. But the
>> job obviously does so I would start there. Look in the DTS package to see
>> where it references these databases. You can also try looking at the job
>> step itself in the job history. You will need to expand the history
>> listing to see the individual steps.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Paul Bergson [MVP-DS]" <pbergson@.allete_nospam.com> wrote in message
>> news:uWt8T$oCIHA.4228@.TK2MSFTNGP02.phx.gbl...
>>I have a SQL Server 2000 db, that has db's unrelated to an application
>>that I run some sql server scheduled tasks. I decided I wanted to dump
>>these old db's, so the first step is to take the db's offline for a week
>>before deleting them. Well for some reason all tasks for an unrelated
>>(?) system would fail and until I brought these unconnected db's back
>>online they wouldn't run.
>> If I went into dts and run the apps they run fine, the Id is my elevated
>> domain admin account. The sql server agent that runs the task is a
>> domain account with local admin privileges.
>> Is there something I can check for to try and get more info? Nothing in
>> the sql logs, in the Event logs this is all I get. Stumped?
>> Event Type: Warning
>> Event Source: SQLSERVERAGENT
>> Event Category: Job Engine
>> Event ID: 208
>> Date: 10/9/2007
>> Time: 11:02:10 AM
>> User: N/A
>> Computer: some_SQL
>> Description:
>> SQL Server Scheduled Job 'Extract_Command_Center_Meters'
>> (0x21F52611A08A0C4F85974069429F69E0) - Status: Failed - Invoked on:
>> 2007-10-09 11:02:10 - Message: The job failed. The Job was invoked by
>> User some_domain\some_admin. The last step to run was step 1
>> (Extract_Command_Center_Meters 2).
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> --
>> Paul Bergson
>> MVP - Directory Services
>> MCT, MCSE, MCSA, Security+, BS CSci
>> 2003, 2000 (Early Achiever), NT
>> http://www.pbbergs.com
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>

scheduled backup question

I currently have the default 'simple' backup mode. I right clicked a
database, chose all tasks, then backup database. Then I chose to do a full
backup to a file device I created. I chose to 'schedule' the backup to occur
once a day. My question: Where do I see this scheduled backup? is there a
place I can see whats currently scheduled? What if I need to edit it?
any info is greatly appreciated.. Thanks.
You can see all the jobs in Enterprise Manager. Under the server, go to
Management > SQL Server Agent > Jobs.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"djc" <noone@.nowhere.com> wrote in message
news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> I currently have the default 'simple' backup mode. I right clicked a
> database, chose all tasks, then backup database. Then I chose to do a full
> backup to a file device I created. I chose to 'schedule' the backup to
occur
> once a day. My question: Where do I see this scheduled backup? is there a
> place I can see whats currently scheduled? What if I need to edit it?
> any info is greatly appreciated.. Thanks.
>
|||thank you.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Ow1YP7RaEHA.2296@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> You can see all the jobs in Enterprise Manager. Under the server, go to
> Management > SQL Server Agent > Jobs.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "djc" <noone@.nowhere.com> wrote in message
> news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
full[vbcol=seagreen]
> occur
a
>

scheduled backup question

I currently have the default 'simple' backup mode. I right clicked a
database, chose all tasks, then backup database. Then I chose to do a full
backup to a file device I created. I chose to 'schedule' the backup to occur
once a day. My question: Where do I see this scheduled backup? is there a
place I can see whats currently scheduled? What if I need to edit it?
any info is greatly appreciated.. Thanks.You can see all the jobs in Enterprise Manager. Under the server, go to
Management > SQL Server Agent > Jobs.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"djc" <noone@.nowhere.com> wrote in message
news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> I currently have the default 'simple' backup mode. I right clicked a
> database, chose all tasks, then backup database. Then I chose to do a full
> backup to a file device I created. I chose to 'schedule' the backup to
occur
> once a day. My question: Where do I see this scheduled backup? is there a
> place I can see whats currently scheduled? What if I need to edit it?
> any info is greatly appreciated.. Thanks.
>|||thank you.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Ow1YP7RaEHA.2296@.TK2MSFTNGP10.phx.gbl...
> You can see all the jobs in Enterprise Manager. Under the server, go to
> Management > SQL Server Agent > Jobs.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "djc" <noone@.nowhere.com> wrote in message
> news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
full[vbcol=seagreen]
> occur
a[vbcol=seagreen]
>

scheduled backup question

I currently have the default 'simple' backup mode. I right clicked a
database, chose all tasks, then backup database. Then I chose to do a full
backup to a file device I created. I chose to 'schedule' the backup to occur
once a day. My question: Where do I see this scheduled backup? is there a
place I can see whats currently scheduled? What if I need to edit it?
any info is greatly appreciated.. Thanks.You can see all the jobs in Enterprise Manager. Under the server, go to
Management > SQL Server Agent > Jobs.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"djc" <noone@.nowhere.com> wrote in message
news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> I currently have the default 'simple' backup mode. I right clicked a
> database, chose all tasks, then backup database. Then I chose to do a full
> backup to a file device I created. I chose to 'schedule' the backup to
occur
> once a day. My question: Where do I see this scheduled backup? is there a
> place I can see whats currently scheduled? What if I need to edit it?
> any info is greatly appreciated.. Thanks.
>|||thank you.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:Ow1YP7RaEHA.2296@.TK2MSFTNGP10.phx.gbl...
> You can see all the jobs in Enterprise Manager. Under the server, go to
> Management > SQL Server Agent > Jobs.
> --
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "djc" <noone@.nowhere.com> wrote in message
> news:umsvf3RaEHA.1488@.TK2MSFTNGP09.phx.gbl...
> > I currently have the default 'simple' backup mode. I right clicked a
> > database, chose all tasks, then backup database. Then I chose to do a
full
> > backup to a file device I created. I chose to 'schedule' the backup to
> occur
> > once a day. My question: Where do I see this scheduled backup? is there
a
> > place I can see whats currently scheduled? What if I need to edit it?
> >
> > any info is greatly appreciated.. Thanks.
> >
> >
>

schedule problem

Hi
I have problem with scheduling tasks.
I have one SP, where I decide to fire or not another SP and I prepare
parameters for this new SP. The problem is I want to fire this new SP
with delay.
For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
at 1:00 AM.
Is it possible to create this programatically ??

Thx for any help and seggestions.

MaciejMaciej (maciej_ty@.poczta.onet.pl) writes:
> I have problem with scheduling tasks.
> I have one SP, where I decide to fire or not another SP and I prepare
> parameters for this new SP. The problem is I want to fire this new SP
> with delay.
> For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
> at 1:00 AM.
> Is it possible to create this programatically ??

There is a whole load of system procedures for SQL Agent, so I guess
this is possible. sp_add_jobschedule may be a start. Please refer to
Books Online for details. See below for a linke to an updated version.
(Disclaimer: I have never done this sort of thing myself.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Schedule backup with SQL 2005 Express

How do I schedule a backup with SQL Server 2005 Express. When I right-click a database and choose Tasks -> Back Up...
I don't get the option to schedule the backup. How do I do?

hi,

SQLExpress does not provide the SQL Server Agent, thus you can not schedule a "native" backup or whatever task via a SQL Server Agent job..

you have to rely on the native OS scheduler, writing your own command file including the actual BACKUP DATABASE... statement to be executed, or on other solutions even based on the OS scheduler, like http://www.sqldbatips.com/showarticle.asp?ID=27 and http://www.sqldbatips.com/showarticle.asp?ID=29, third party solutions like http://www.lazycoding.com/products.aspx or http://www.valesoftware.com/products-express-agent.php, http://www.codeproject.com/vb/net/SQLAgent.asp, or custom solutions based on the Service Broker as indicated in http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx

regards|||

Ok! Thanks.

Is SQL Server 2005 Express edition the only one that do not provide the SQL Server Agent?

|||

Thats right.

See the information from here:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

SQL Agent Job Scheduling Service

Jens K. Suessmeyer.

http://www.sqlserver2008.de

|||Excuse me, could you please tell me how can you backup your database use the Sql Express ?
I just want to use the osql -E order, but the system tell me that it fail to connect to the database, it may caused by the remote connections closed, but actually I allow the remote connection.
Is there another way to backup the database in the sql Express?
|||

The complete syntax for backup is proveded in Books Online, please search there for syntax help. If you are not being allowed to login, then you are either providing the wrong instance name or you are using an account that doesn't have permissions.

The most common error people make with SQL Express is that it is installed by default to an instance name, not the default instance, so you have to pass the entire instance name when connectiong:

osql -S <machine>\SQLEXPRESS -E ...

See if adding the instance name resolves your problem.

Mike

|||

If you are unfamiliar with the BACKUP syntax, you can use the UI command of SSMS(Express) and create a script which can be laterone copied to the AT job using the SQLCMD utility as Mike mentioned.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Schedule backup with SQL 2005 Express

How do I schedule a backup with SQL Server 2005 Express. When I right-click a database and choose Tasks -> Back Up...
I don't get the option to schedule the backup. How do I do?

hi,

SQLExpress does not provide the SQL Server Agent, thus you can not schedule a "native" backup or whatever task via a SQL Server Agent job..

you have to rely on the native OS scheduler, writing your own command file including the actual BACKUP DATABASE... statement to be executed, or on other solutions even based on the OS scheduler, like http://www.sqldbatips.com/showarticle.asp?ID=27 and http://www.sqldbatips.com/showarticle.asp?ID=29, third party solutions like http://www.lazycoding.com/products.aspx or http://www.valesoftware.com/products-express-agent.php, http://www.codeproject.com/vb/net/SQLAgent.asp, or custom solutions based on the Service Broker as indicated in http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx

regards|||

Ok! Thanks.

Is SQL Server 2005 Express edition the only one that do not provide the SQL Server Agent?

|||

Thats right.

See the information from here:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

SQL Agent Job Scheduling Service

Jens K. Suessmeyer.

http://www.sqlserver2008.de

|||Excuse me, could you please tell me how can you backup your database use the Sql Express ?
I just want to use the osql -E order, but the system tell me that it fail to connect to the database, it may caused by the remote connections closed, but actually I allow the remote connection.
Is there another way to backup the database in the sql Express?
|||

The complete syntax for backup is proveded in Books Online, please search there for syntax help. If you are not being allowed to login, then you are either providing the wrong instance name or you are using an account that doesn't have permissions.

The most common error people make with SQL Express is that it is installed by default to an instance name, not the default instance, so you have to pass the entire instance name when connectiong:

osql -S <machine>\SQLEXPRESS -E ...

See if adding the instance name resolves your problem.

Mike

|||

If you are unfamiliar with the BACKUP syntax, you can use the UI command of SSMS(Express) and create a script which can be laterone copied to the AT job using the SQLCMD utility as Mike mentioned.

Jens K. Suessmeyer

http://www.sqlserver2005.de