Can Job Frequency go less than one minute?

Hi,
I'd like to schedule a job on my utility server to run every 15 seconds. Is
it possible to do that in SQL Agent?
Thanks,What kind of task is it ?
--
Message posted via http://www.sqlmonster.com|||You create on job and loop this job with issuing a wait statement for the
time the job didn´t take place.
WAITFOR DELAY '000:00:15'
OR evaluating the time when the last start took and ended and substract that
from the 15 seconds.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Kam" <Kam@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,|||Have a look at http://sqldev.net/sqlagent/SQLAgentRecuringJobsInSecs.htm
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,

Can Job Frequency go less than one minute?

Hi,
I'd like to schedule a job on my utility server to run every 15 seconds. Is
it possible to do that in SQL Agent?
Thanks,
What kind of task is it ?
Message posted via http://www.droptable.com
|||You create on job and loop this job with issuing a wait statement for the
time the job didnt take place.
WAITFOR DELAY '000:00:15'
OR evaluating the time when the last start took and ended and substract that
from the 15 seconds.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Kam" <Kam@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,
|||Have a look at http://sqldev.net/sqlagent/SQLAgentR...JobsInSecs.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,

Can Job Frequency go less than one minute?

Hi,
I'd like to schedule a job on my utility server to run every 15 seconds. Is
it possible to do that in SQL Agent?
Thanks,What kind of task is it ?
Message posted via http://www.droptable.com|||You create on job and loop this job with issuing a wait statement for the
time the job didnt take place.
WAITFOR DELAY '000:00:15'
OR evaluating the time when the last start took and ended and substract that
from the 15 seconds.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Kam" <Kam@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,|||Have a look at http://sqldev.net/sqlagent/SQLAgent...gJobsInSecs.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,

Can I use SQL server 2005 manager to schedule backups?

Can I use SQL server 2005 manager to schedule backups?
Any documents for that?
Thanks in advance.
Sean wrote:
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.
Create a SQL Agent job that executes the BACKUP command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Hi,
You could also use the Maintenance plans from SQL Server Management studio
to configure the database backup. The wizard itself will guide you to steps
to setup the backup job.
Thanks
Hari
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:F1DC9D76-2519-42A4-807A-1D788D9B8A3F@.microsoft.com...
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.

Can I use SQL server 2005 manager to schedule backups?

Can I use SQL server 2005 manager to schedule backups?
Any documents for that?
Thanks in advance.Sean wrote:
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.
Create a SQL Agent job that executes the BACKUP command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi,
You could also use the Maintenance plans from SQL Server Management studio
to configure the database backup. The wizard itself will guide you to steps
to setup the backup job.
Thanks
Hari
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:F1DC9D76-2519-42A4-807A-1D788D9B8A3F@.microsoft.com...
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.

Can I use SQL server 2005 manager to schedule backups?

Can I use SQL server 2005 manager to schedule backups?
Any documents for that?
Thanks in advance.Sean wrote:
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.
Create a SQL Agent job that executes the BACKUP command...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi,
You could also use the Maintenance plans from SQL Server Management studio
to configure the database backup. The wizard itself will guide you to steps
to setup the backup job.
Thanks
Hari
SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:F1DC9D76-2519-42A4-807A-1D788D9B8A3F@.microsoft.com...
> Can I use SQL server 2005 manager to schedule backups?
> Any documents for that?
> Thanks in advance.

Can I shedule packages from C#.net

I want to know what is the schedule of packages. and be able to change them from my .net Program.

ThanksYou can use the SSIS object model to execute packages directly, or you can schedule packages to run through SMO with the SMO.Agent namespace objects.
It's documented here: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/smo9mref/html/N_Microsoft_SqlServer_Management_Smo_Agent.htm
Thanks,
Kirk Haselden
Dev. Mngr
SSIS

Can I schedule SQL extract using SQL Server Express

I have downloaded almost all file related to SQL Server 2005 Express edition. Before I wast time finding out that what I want to do it not possible afteral.

What I want to is to connect to an SQL Server and extract data from that into my local db (Gues that will be my local SQL server db?) and than pass the data onto MS Access.

My question is: can I automate this procedure I.e. schedule to download and export to Access using the Express Edition.

Appreciate any feedback

Thanks,
BogdanHi Bogdan,
SQL Express does not include the SQL Agent, so it does not support any kind of scheduling for anything. What you can do is create a script that does what you and can be run via SQLCmd. You can then use the Windows Task Scheduler to schedule SQLCmd to run and use the script you created.
This same procedure can be used for any scheduled task you wish to perform when using SQL Express.
Regards,

Mike|||

yes, thanks and this is the code for the batch-file

Rem1 connect SLQ-Server (ServerName = SQLExpress)
Rem2 within command line 'use' is used for selected dB, however directly from prompt it is -d. My db name is 'Bogdan'
Rem3 Select Query to execute (from file) within command line ':r', to activate cmd use -q (or -Q to quit to connection).
Rem4 Execute 'Go' not necessary

sqlcmd -S .\SQLExpress -d Bogdan -Q ":r C:\SQL_Server_Queries\SQL_CreateQuery.sql"
Bogdan