Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominic
Check out Jobs in the BOL. Each job can have multiple steps and multiple
schedules. Each step can be VBScript or T-SQL or OS command or ...
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dominic Marsat" <djmarsatAThotmail.com> wrote in message
news:eqXtuuGKEHA.2380@.TK2MSFTNGP09.phx.gbl...
Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominic
Showing posts with label ive. Show all posts
Showing posts with label ive. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Scheduling a job under SA
I've shceduled a job under sa account (I've changed the password
though
),this job access local folder of the box running SQL server.I have
added sa to the sysadmin role and it dose have access to the local folder
..How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lot
If the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:
>I've shceduled a job under sa account (I've changed the password
>though),this job access local folder of the box running SQL server.I have
>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>
|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>
though
),this job access local folder of the box running SQL server.I haveadded sa to the sysadmin role and it dose have access to the local folder
..How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lot
If the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:
>I've shceduled a job under sa account (I've changed the password
>though
),this job access local folder of the box running SQL server.I have>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>
|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>
Friday, March 23, 2012
Scheduling a backup on SQL Server Express
Hi,
is there a way to schedule a backup ?
Using the Management Studio Express I've seen only the way to Backup a
database but not to "schedule" a backup.
Any help or suggestion is appreciated
Adriano
hi Adriano,
Adry wrote:
> Hi,
> is there a way to schedule a backup ?
> Using the Management Studio Express I've seen only the way to Backup a
> database but not to "schedule" a backup.
>
unfortunately, SQLExpress does not provide the SQL Server Agent, so you have
to rely on os scheduled (AT, SCHTASKS) scripts to be run via osql.exe or
sqlcmd.exe...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
is there a way to schedule a backup ?
Using the Management Studio Express I've seen only the way to Backup a
database but not to "schedule" a backup.
Any help or suggestion is appreciated
Adriano
hi Adriano,
Adry wrote:
> Hi,
> is there a way to schedule a backup ?
> Using the Management Studio Express I've seen only the way to Backup a
> database but not to "schedule" a backup.
>
unfortunately, SQLExpress does not provide the SQL Server Agent, so you have
to rely on os scheduled (AT, SCHTASKS) scripts to be run via osql.exe or
sqlcmd.exe...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 7, 2012
Schedule package upon deploymnent
hi all!
ive created a package that's supposed to run every night. the package works fine and is now ready for deployment so ive created a deployment utility for this (is this the best way to deploy?) what i want to know is is there a way to set the package to run every night upon deployment?
Hi,
The deployment utility is a fine way to deploy packages, but you have to take the next step to setup a job manually.
|||Use SQL Server Agent to schedule your job.If deploying to the file system, you don't need a deployment utility -- you can just copy the .dtsx and any configuration files over to the file system.
Phil
Subscribe to:
Posts (Atom)