T-SQL Script: manager

Showing posts with label manager. Show all posts

Wednesday, March 28, 2012

Scheduling DTS Package using a stored procedure problem

The DTS package runs fine through Enterprise manager successfully.
However, when scheduled through a job that runs the dts through the
following code:

DECLARE @.findfile int
Exec @.findfile = master.dbo.xp_cmdShell 'dir
\\ServerName\folder\filename.xls', no_output
IF (@.findfile=0)
BEGIN
Exec master.dbo.xp_cmdshell 'dtsrun -E -Server\Instance
-N"DataImport"'
END

The servername specified in the above statement in a different server
than the server that the package resides on.

This is the error that I get when I try to run the same code using
query analyzer:

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147024893
(80070003)
Error string: The system cannot find the path specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147024893 (80070003); Provider Error: 0 (0)
Error string: The system cannot find the path specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error: -2147024893 (80070003); Provider Error: 0 (0)
Error string: Cannot open a log file of specified name. The system
cannot find the path specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4700

DTSRun OnFinish: DTSStep_DTSDataPumpTask_1

Error: -2147220440 (80040428); Provider Error: 0 (0)
Error string: Package failed because Step
'DTSStep_DTSDataPumpTask_1' failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700

NULL

The job is owned by the SQLService account(Windows account) that has
System Admin rights and also is part of the Domain Admin User group.
The Domain Admin User group has full rights on the file that the DTS is
trying to access.

Any help in trying to figure out why the schedule job cannot find the
file path would be appreciated.

Thanks

KRI found the problem was the path in the log file : was using a mapped
drive vs a UNC path.

Monday, March 26, 2012

Scheduling a Report

Hello,
I am trying to create a schedule to add snapshots of a certain report to
report history.
So in Report Manager, I go to History and create a schedule to to this. In
my understanding, i need to create a job to execute this shedule. So i go to
Enterprise Manager to create a job. But after this i am lost, basically. How
can i reference this schedule when i go to "New Job". Is there any code that
needs to be put in the "New Job" Wizard so that this schedule can be run?
Thanks
SanjeevYou do not go to Enterprise Manager to do this. Do it all from within Report
Manager.
First create your schedule using Site Settings, Manage shared schedules. Do
this if you want to re-use the schedule with other reports.
Next, navigate to the report's folder and bring up its Properties window.
With the Properties window displayed, there is a History link on the left
side of the screen. Check the option to "Use the following schedule to add
snapshots to report history", then specify the schedule underneath.
HTH
Charles Kangai, MCT, MCDBA
"Sanjeev" wrote:
> Hello,
> I am trying to create a schedule to add snapshots of a certain report to
> report history.
> So in Report Manager, I go to History and create a schedule to to this. In
> my understanding, i need to create a job to execute this shedule. So i go to
> Enterprise Manager to create a job. But after this i am lost, basically. How
> can i reference this schedule when i go to "New Job". Is there any code that
> needs to be put in the "New Job" Wizard so that this schedule can be run?
> Thanks
> Sanjeev
>
>|||Thanks Charles. That worked
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:3D77E5E5-BAE9-484B-A87C-714EAD5350FC@.microsoft.com...
> You do not go to Enterprise Manager to do this. Do it all from within
> Report
> Manager.
> First create your schedule using Site Settings, Manage shared schedules.
> Do
> this if you want to re-use the schedule with other reports.
> Next, navigate to the report's folder and bring up its Properties window.
> With the Properties window displayed, there is a History link on the left
> side of the screen. Check the option to "Use the following schedule to add
> snapshots to report history", then specify the schedule underneath.
> HTH
> Charles Kangai, MCT, MCDBA
> "Sanjeev" wrote:
>> Hello,
>> I am trying to create a schedule to add snapshots of a certain report to
>> report history.
>> So in Report Manager, I go to History and create a schedule to to this.
>> In
>> my understanding, i need to create a job to execute this shedule. So i go
>> to
>> Enterprise Manager to create a job. But after this i am lost, basically.
>> How
>> can i reference this schedule when i go to "New Job". Is there any code
>> that
>> needs to be put in the "New Job" Wizard so that this schedule can be run?
>> Thanks
>> Sanjeev
>>

scheduling a query

I need to scheduling a query to update some records.
I have to use a script in windows task manager or there is another way?
Many ThanksThe SQL Agent is a wonderful wat to schedule a query. Create a job and out
your query in a step.
"Simone" wrote:

> I need to scheduling a query to update some records.
> I have to use a script in windows task manager or there is another way?
> Many Thanks
>
>|||If you are using an edition of SQL Server which has an enterprise
manager and therefor a UI for SQL Server Agent, you can just create a
job with your query. Add a new job, add a new step (Transact SQL
Execution), paste your statement in there and add a schedule for it and
voil=E1, you=B4re done. iof you do=B4n=B4t have a GUI, you can use the
goold old fashioned AT to do your jobs. Just schedule your job by the
Windows Scheduler or AT, suing OSQL to run the query: OSQL -SServername
-UUsername -PPassword -Q"Here is my query".
HTH, jens Suessmeyer.|||you can create a job and schedule that
Jobs are under management-->Sql Server agent-->Jobs
make it a one step job paste your query or proc call in the step
command window and schedule the job
http://sqlservercode.blogspot.com/

scheduling a query

I need to scheduling a query to update some records.
I have to use a script in windows task manager or there is another way?
Many ThanksIf you are using an edition of SQL Server which has an enterprise
manager and therefor a UI for SQL Server Agent, you can just create a
job with your query. Add a new job, add a new step (Transact SQL
Execution), paste your statement in there and add a schedule for it and
voil=E1, you=B4re done. iof you do=B4n=B4t have a GUI, you can use the
goold old fashioned AT to do your jobs. Just schedule your job by the
Windows Scheduler or AT, suing OSQL to run the query: OSQL -SServername
-UUsername -PPassword -Q"Here is my query".
HTH, jens Suessmeyer.|||The SQL Agent is a wonderful wat to schedule a query. Create a job and out
your query in a step.
"Simone" wrote:
> I need to scheduling a query to update some records.
> I have to use a script in windows task manager or there is another way?
> Many Thanks
>
>|||you can create a job and schedule that
Jobs are under management-->Sql Server agent-->Jobs
make it a one step job paste your query or proc call in the step
command window and schedule the job
http://sqlservercode.blogspot.com/

scheduling a query

I need to scheduling a query to update some records.
I have to use a script in windows task manager or there is another way?
Many Thanks
The SQL Agent is a wonderful wat to schedule a query. Create a job and out
your query in a step.
"Simone" wrote:

> I need to scheduling a query to update some records.
> I have to use a script in windows task manager or there is another way?
> Many Thanks
>
>
|||If you are using an edition of SQL Server which has an enterprise
manager and therefor a UI for SQL Server Agent, you can just create a
job with your query. Add a new job, add a new step (Transact SQL
Execution), paste your statement in there and add a schedule for it and
voil=E1, you=B4re done. iof you do=B4n=B4t have a GUI, you can use the
goold old fashioned AT to do your jobs. Just schedule your job by the
Windows Scheduler or AT, suing OSQL to run the query: OSQL -SServername
-UUsername -PPassword -Q"Here is my query".
HTH, jens Suessmeyer.
|||you can create a job and schedule that
Jobs are under management-->Sql Server agent-->Jobs
make it a one step job paste your query or proc call in the step
command window and schedule the job
http://sqlservercode.blogspot.com/

Friday, March 23, 2012

Scheduling a DTS package without admin privileges.

I have created a dts package that I can execute from within sql server
enterprise manager. However, I don’t have admin privileges so when I
schedule a job within sql server it fails to execute because I don’t have
the
necessary privileges.
Since I have the privileges to run the DTS package I have created I am
interested in another means of scheduling my DTS package. I was thinking of
making use of the windows task scheduler or if that is not possible making a
windows service.
Right now I am using the dtsrun.exe but I can only use this if sql
server is installed on the machine that requests the DTS package to be
executed. I was hoping to find a way to request the DTS Package to be run
from any machine of my choosing. I got excited when I found the DTS com dl
l
but it appears only to provide a wrapper that communicates with the locally
installed sqlserver. Is there another way to do this other than have admin
privileges and keep it on the actually server? For now I have created a dts
substitute…Basically I have every thing I need to do in a series of stored
procedures and I call that from a windows task scheduler. (However I am
missing email and other capabilities.) Do I really need admin privileges to
be able to schedule a DTS package?Hello,
The security context in which the DTS job is run is determined by the owner
of the job. If the job is owned by a login that is not a member of the
Sy

min server role, then the package is run under the context of the
account setup as the SQL Agent Proxy Account, and has the rights and
permissions of that account.
For SQL Agent Proxy to be able to run jobs that connect to SQL Server, the
SQL Agent Proxy account must have proper Windows/NT permissions and be
granted login access to SQL Server with appropriate database permissions.
For the jobs that execute a DTS package, the SQL Agent Proxy Account must
have read and write permissions to the temp directory of the Account the
SQL Server Agent is running under. For example,
c:\Documents and Settings\<Account>\Local Settings\Temp
You may want to look at the following article:
http://support.microsoft.com/defaul...kb;en-us;269074
also the security discussions at:
http://support.microsoft.com/defaul...kb;en-us;252987
http://support.microsoft.com/defaul...kb;en-us;322746
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Scheduling a DTS package without admin privileges.
>thread-index: AcZD0ZYb2apHTm+GQoGmib/7CppZqQ==
>X-WBNR-Posting-Host: 66.162.65.194
>From: examnotes <JeffDotNet@.newsgroups.nospam>
>Subject: Scheduling a DTS package without admin privileges.
>Date: Thu, 9 Mar 2006 15:31:27 -0800
>Lines: 20
>Message-ID: <2AB4DFE2-6F42-4DD5-8AAF-339819986F39@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.programming
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.programming:586021
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.programming
>I have created a dts package that I can execute from within sql server
>enterprise manager. However, I don’t have admin privileges so when I
>schedule a job within sql server it fails to execute because I don’t
have the
>necessary privileges.
> Since I have the privileges to run the DTS package I have created I am
>interested in another means of scheduling my DTS package. I was thinking
of
>making use of the windows task scheduler or if that is not possible making
a
>windows service.
> Right now I am using the dtsrun.exe but I can only use this if sql
>server is installed on the machine that requests the DTS package to be
>executed. I was hoping to find a way to request the DTS Package to be run
>from any machine of my choosing. I got excited when I found the DTS com
dll
>but it appears only to provide a wrapper that communicates with the
locally
>installed sqlserver. Is there another way to do this other than have
admin
>privileges and keep it on the actually server? For now I have created a
dts
>substitute…Basically I have every thing I need to do in a series of
stored
>procedures and I call that from a windows task scheduler. (However I am
>missing email and other capabilities.) Do I really need admin privileges
to
>be able to schedule a DTS package?
>

Scheduling a DTS package

I am using Enterprise manager with an MSDE engine. I have created a DTS package that updates a table in one of the databases. If I right click and choose "Execute Package" it runs...No sweat. When I try to use the scheduler to run the job every hour, it always fails between 1 and 10 seconds into the job...It only returns the error "Failed During Step 1."

I'm wondering if this feature won't work with MSDE? Does anyone have any ideas?Under Management>Jobs, right click on the job in question, and select "Job History". There should be a checkbox that says "Show step details". Clicking that will expand the information. Check to see if there's more information in there.|||Probably a security issue. Wen you run the package interactively it uses the logged in user, when running from the job queue it uses the configured user account of the DTS Package.

Open your package, click Package->Properties->Logging|||Thanks for tips, the error is:

Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: The system cannot find the path specified.

Step Error code: 80004005
Step Error Help File:DTSFFile.hlp
Step Error Help Context ID:0

I checked the path and it's correct, and it finds the file when I run it manually.|||Check the server to see if the file exists in the exact same filepath as on your machine. I believe that when you run a DTS package interactively, it resolves file names locally, but when executed from the server via SQLAgent it will resolve the filepaths from the server.|||i concurr
i suck at typing in filepaths so i always set the windows explorer to display the full path in the title bar and i just copy it from there.

Wednesday, March 21, 2012

Scheduled reports never run

I can run reports in Report Manager, but none of the subscriptions I set up
ever run. I have tried creating subscriptions that run both at a preset
time and according to a shared schedule. In the ReportServerService log
files, I see that polling of various types is initiated but nothing after
that. The Cleanup runs every 10 minutes but nothing elese does. See log
file below:
ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Initializing crypto as user: Proposion\Steve
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Exporting
public key
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: EventPolling
polling service started
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
NotificationPolling polling service started
ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling started
ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
Shouldn't there at least be an indication that events are triggered and why
reports can't run?
Interestingly, if I look at the Shared Schedules in Report Manager and the
"Next Run" shows the expected time (which has now elapsed) but the "Last
Run" still says "Never Run".
I have tries restarting SQLSERVERAGENT and Reporting Service services, as
well as completely rebooting.
Thanks for your help!Is there an error listed on the job in JOBS on the SQL server? And if so what are they?
"Stephen Walch" <swalch@.proposion.com> wrote in message news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> I can run reports in Report Manager, but none of the subscriptions I set up
> ever run. I have tried creating subscriptions that run both at a preset
> time and according to a shared schedule. In the ReportServerService log
> files, I see that polling of various types is initiated but nothing after
> that. The Cleanup runs every 10 minutes but nothing elese does. See log
> file below:
> ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO: Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Initializing crypto as user: Proposion\Steve
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling started
> ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
> Shouldn't there at least be an indication that events are triggered and why
> reports can't run?
> Interestingly, if I look at the Shared Schedules in Report Manager and the
> "Next Run" shows the expected time (which has now elapsed) but the "Last
> Run" still says "Never Run".
> I have tries restarting SQLSERVERAGENT and Reporting Service services, as
> well as completely rebooting.
> Thanks for your help!
>|||I see no files listed in the "C:\Program Files\Microsoft SQL
Server\MSSQL\JOBS" directory, if that is what you mean. (Sorry I am rather
new to SQL server.)
-Steve
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:e%23btTsTWEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Is there an error listed on the job in JOBS on the SQL server? And if so
what are they?
> "Stephen Walch" <swalch@.proposion.com> wrote in message
news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > I can run reports in Report Manager, but none of the subscriptions I set
up
> > ever run. I have tried creating subscriptions that run both at a preset
> > time and according to a shared schedule. In the ReportServerService log
> > files, I see that polling of various types is initiated but nothing
after
> > that. The Cleanup runs every 10 minutes but nothing elese does. See log
> > file below:
> >
> > ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i
INFO:
> > Reporting Services starting SKU: Developer
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Running Requests DB timer enabled: Cycle: 60 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
Memory
> > stats update timer enabled: Cycle: 60 seconds
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> > Initializing crypto as user: Proposion\Steve
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Exporting
> > public key
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Performing
> > sku validation
> > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
Importing
> > existing encryption key
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
EventPolling
> > polling service started
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> > NotificationPolling polling service started
> > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
SchedulePolling
> > polling service started
> > ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> > heartbeat thread started.
> > ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> > NotificationPolling heartbeat thread started.
> > ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling
started
> > ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> > ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> > ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO:
Cleaned 0
> > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> >
> > Shouldn't there at least be an indication that events are triggered and
why
> > reports can't run?
> >
> > Interestingly, if I look at the Shared Schedules in Report Manager and
the
> > "Next Run" shows the expected time (which has now elapsed) but the "Last
> > Run" still says "Never Run".
> >
> > I have tries restarting SQLSERVERAGENT and Reporting Service services,
as
> > well as completely rebooting.
> >
> > Thanks for your help!
> >
> >
>|||If you go into Enterprise Manager and then:
Management -> SQL Server Agent -> Jobs there will be a list of all the jobs on your server (SQL Server Agent is like a daemon that
runs in the backgroup and runs timed tasks on the server, this is what reporting services uses to kick off reports that are on a
schedule)
One you see all the jobs you will find out that all your reporting services schedules are a mixture of letters and numbers. If you
look in the "Last Run Status" column you should see one with "Failed" (You can sort out the list by clicking on the "category" title
and looking where "Report Server" is entered. Right click on your failed job and choose "View job History". Then check the "Show
step details" box on the top right of the dialog box.
You can then click on the steps and get the server messages for that step (if any). Any error message information will be stored
there.
"Stephen Walch" <swalch@.proposion.com> wrote in message news:%23Jb%23yAVWEHA.3944@.tk2msftngp13.phx.gbl...
> I see no files listed in the "C:\Program Files\Microsoft SQL
> Server\MSSQL\JOBS" directory, if that is what you mean. (Sorry I am rather
> new to SQL server.)
> -Steve
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:e%23btTsTWEHA.3120@.TK2MSFTNGP12.phx.gbl...
> > Is there an error listed on the job in JOBS on the SQL server? And if so
> what are they?
> >
> > "Stephen Walch" <swalch@.proposion.com> wrote in message
> news:eqzhZkTWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > I can run reports in Report Manager, but none of the subscriptions I set
> up
> > > ever run. I have tried creating subscriptions that run both at a preset
> > > time and according to a shared schedule. In the ReportServerService log
> > > files, I see that polling of various types is initiated but nothing
> after
> > > that. The Cleanup runs every 10 minutes but nothing elese does. See log
> > > file below:
> > >
> > > ReportingServicesService!resourceutilities!17c!6/23/2004-07:27:56:: i
> INFO:
> > > Reporting Services starting SKU: Developer
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Running Requests Scavenger timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Running Requests DB timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> > > Execution Log Entry Expiration timer enabled: Cycle: 66723 seconds
> > > ReportingServicesService!runningjobs!17c!6/23/2004-07:27:56:: i INFO:
> Memory
> > > stats update timer enabled: Cycle: 60 seconds
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> > > Initializing crypto as user: Proposion\Steve
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Exporting
> > > public key
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Performing
> > > sku validation
> > > ReportingServicesService!crypto!d88!6/23/2004-07:27:57:: i INFO:
> Importing
> > > existing encryption key
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> EventPolling
> > > polling service started
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> > > NotificationPolling polling service started
> > > ReportingServicesService!dbpolling!d88!06/23/2004-07:27:57::
> SchedulePolling
> > > polling service started
> > > ReportingServicesService!dbpolling!ef0!6/23/2004-07:27:57:: EventPolling
> > > heartbeat thread started.
> > > ReportingServicesService!dbpolling!e04!6/23/2004-07:27:57::
> > > NotificationPolling heartbeat thread started.
> > > ReportingServicesService!dbpolling!f84!6/23/2004-07:27:57:: Polling
> started
> > > ReportingServicesService!library!17c!6/23/2004-07:46:09:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > > ReportingServicesService!library!17c!6/23/2004-07:56:06:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > > ReportingServicesService!library!17c!6/23/2004-08:06:06:: i INFO:
> Cleaned 0
> > > batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > > chunks, 0 running jobs
> > >
> > >
> > > Shouldn't there at least be an indication that events are triggered and
> why
> > > reports can't run?
> > >
> > > Interestingly, if I look at the Shared Schedules in Report Manager and
> the
> > > "Next Run" shows the expected time (which has now elapsed) but the "Last
> > > Run" still says "Never Run".
> > >
> > > I have tries restarting SQLSERVERAGENT and Reporting Service services,
> as
> > > well as completely rebooting.
> > >
> > > Thanks for your help!
> > >
> > >
> >
> >
>sql

Tuesday, March 20, 2012

Scheduled Job Not Working

I have created a scheduled job in the enterprise manager, which checks around 20 different date columns and replaces any non-dates with NULL using the following syntax: -

update policy set [exp] =null where isdate (substring([exp],4,2)+'-'+left([exp],2)+'-'+'200'+right ([exp],1 ))=0
go
update policy set [eff] =null where isdate (substring([eff],4,2)+'-'+left([eff],2)+'-'+'200'+right ([eff],1 ))=0
go
update policy set [written] =null where isdate (substring([written],4,2)+'-'+left([written],2)+'-'+'200'+right ([written],1 ))=0
go

etc......

When I start the job, if fails within 2 seconds. If I copy the syntax in to the query analyzer it works fine.

All help appreciated.

A couple of questions

1 what is the error

2 who is the owner of the Job (and does he have permissions to the DB)

3 is the correct DB seleted in the step?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

to view the errro message , right click on the job, select view job history, click show step details (top right)

Click on the stepid and the error will be displayed in the bottom part

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

Hi there,

The error message is: The job failed. The Job was invoked by User KEELAN_WESTALL\James. The last step to run was step 1 (UpdateDates).

The user is James (me)

I have security to the server/database/tables etc.

The correct DB is selected.

|||

The error message is: -

Executed as user: sa. The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. [SQLSTATE 22018] (Error 256) The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. [SQLSTATE 22018] (Error 256) The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. [SQLSTATE 22018] (Error 256). The step failed.

|||

Convert to varchar first, take a look at this

select substring(1952005,1,2) -- will fail

select substring(convert(varchar(8),1952005),1,2) -- correct

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

As a test I ran the job just changing one column using the following syntax: -

update policy set [exp] =null where isdate (convert (varchar(8), (substring([eff],4,2)+'/'+left([eff],2)+'/'+'200'+right ([eff],1))))=0
go

It worked perfectly.

Thanks very much Denis.

Monday, March 12, 2012

Scheduled Job Error

I am having an issue with a dts package.
I am able to execute the package as myself from enterprise manager but
I recieve an error when running it as a scheduled job. I have read
http://support.microsoft.com/kb/269074/en-us and am either missing
something (highly likly) or it doesn't apply to my particular set of
circumstances.
The dts task uses a "Text File (destination)" Object with a unc path in
its properties
\\remoteserver\d$\nested\folder\input.txt
The job is owned by SA and is executed by our domains sql account
\\mydomain\sqlservice
\\mydomain\sqlservice has been set up with identical permission as
\\mydomain\myaccount to \\remoteserver\d$\nested\folder\
>From the header of the package logs
Executed as user:
MYDOMAIN\sqlservice.
...Start: DTSStep_DTSExecuteSQLTask_1
SQL Task 1 runs just fine (import routines which massage data from
\\anotherserver\inputdir)
Then as soon as it tries to export the file it fails.
DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
(80004005)
Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp Help co...
Process Exit Code 1.
The step failed.
Seems like a cut and dried case of permissions - but
\\MYDOMAIN\sqlservice has access to the location.
ARRRG! Please advise.
Maxmake sure that your sql server agent is running. Look under the management
folder in IE and it should have a green arrow in front of it, if it had a red
square it is not running.
--
Paul G
Software engineer.
"xamfear@.comcast.net" wrote:
> I am having an issue with a dts package.
> I am able to execute the package as myself from enterprise manager but
> I recieve an error when running it as a scheduled job. I have read
> http://support.microsoft.com/kb/269074/en-us and am either missing
> something (highly likly) or it doesn't apply to my particular set of
> circumstances.
> The dts task uses a "Text File (destination)" Object with a unc path in
> its properties
> \\remoteserver\d$\nested\folder\input.txt
> The job is owned by SA and is executed by our domains sql account
> \\mydomain\sqlservice
> \\mydomain\sqlservice has been set up with identical permission as
> \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> >From the header of the package logs
> Executed as user:
> MYDOMAIN\sqlservice.
> ...Start: DTSStep_DTSExecuteSQLTask_1
> SQL Task 1 runs just fine (import routines which massage data from
> \\anotherserver\inputdir)
> Then as soon as it tries to export the file it fails.
> DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> (80004005)
> Error string: Error opening datafile: Access is denied.
> Error source: Microsoft Data Transformation Services Flat File Rowset
> Provider
> Help file: DTSFFile.hlp Help co...
> Process Exit Code 1.
> The step failed.
> Seems like a cut and dried case of permissions - but
> \\MYDOMAIN\sqlservice has access to the location.
> ARRRG! Please advise.
> Max
>|||look under the management folder in Enterprise manager, not IE as I specified
below.
--
Paul G
Software engineer.
"Paul" wrote:
> make sure that your sql server agent is running. Look under the management
> folder in IE and it should have a green arrow in front of it, if it had a red
> square it is not running.
> --
> Paul G
> Software engineer.
>
> "xamfear@.comcast.net" wrote:
> > I am having an issue with a dts package.
> > I am able to execute the package as myself from enterprise manager but
> > I recieve an error when running it as a scheduled job. I have read
> > http://support.microsoft.com/kb/269074/en-us and am either missing
> > something (highly likly) or it doesn't apply to my particular set of
> > circumstances.
> >
> > The dts task uses a "Text File (destination)" Object with a unc path in
> > its properties
> > \\remoteserver\d$\nested\folder\input.txt
> >
> > The job is owned by SA and is executed by our domains sql account
> > \\mydomain\sqlservice
> >
> > \\mydomain\sqlservice has been set up with identical permission as
> > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> >
> > >From the header of the package logs
> > Executed as user:
> > MYDOMAIN\sqlservice.
> > ...Start: DTSStep_DTSExecuteSQLTask_1
> >
> > SQL Task 1 runs just fine (import routines which massage data from
> > \\anotherserver\inputdir)
> > Then as soon as it tries to export the file it fails.
> >
> > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > (80004005)
> > Error string: Error opening datafile: Access is denied.
> > Error source: Microsoft Data Transformation Services Flat File Rowset
> > Provider
> > Help file: DTSFFile.hlp Help co...
> > Process Exit Code 1.
> > The step failed.
> >
> > Seems like a cut and dried case of permissions - but
> > \\MYDOMAIN\sqlservice has access to the location.
> >
> > ARRRG! Please advise.
> > Max
> >
> >|||Thanks for taking the time to reply Paul. The agent is running, and we
know it runs fine since other jobs are run as the agent just fine, and
in this case the other steps of the Job execute fine as well.
Thanks
Max
Paul wrote:
> look under the management folder in Enterprise manager, not IE as I specified
> below.
> --
> Paul G
> Software engineer.
>
> "Paul" wrote:
> > make sure that your sql server agent is running. Look under the management
> > folder in IE and it should have a green arrow in front of it, if it had a red
> > square it is not running.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "xamfear@.comcast.net" wrote:
> >
> > > I am having an issue with a dts package.
> > > I am able to execute the package as myself from enterprise manager but
> > > I recieve an error when running it as a scheduled job. I have read
> > > http://support.microsoft.com/kb/269074/en-us and am either missing
> > > something (highly likly) or it doesn't apply to my particular set of
> > > circumstances.
> > >
> > > The dts task uses a "Text File (destination)" Object with a unc path in
> > > its properties
> > > \\remoteserver\d$\nested\folder\input.txt
> > >
> > > The job is owned by SA and is executed by our domains sql account
> > > \\mydomain\sqlservice
> > >
> > > \\mydomain\sqlservice has been set up with identical permission as
> > > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> > >
> > > >From the header of the package logs
> > > Executed as user:
> > > MYDOMAIN\sqlservice.
> > > ...Start: DTSStep_DTSExecuteSQLTask_1
> > >
> > > SQL Task 1 runs just fine (import routines which massage data from
> > > \\anotherserver\inputdir)
> > > Then as soon as it tries to export the file it fails.
> > >
> > > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > > (80004005)
> > > Error string: Error opening datafile: Access is denied.
> > > Error source: Microsoft Data Transformation Services Flat File Rowset
> > > Provider
> > > Help file: DTSFFile.hlp Help co...
> > > Process Exit Code 1.
> > > The step failed.
> > >
> > > Seems like a cut and dried case of permissions - but
> > > \\MYDOMAIN\sqlservice has access to the location.
> > >
> > > ARRRG! Please advise.
> > > Max
> > >
> > >|||ok, not sure off hand what the problem is, hopefully someone will respond
shortly.
--
Paul G
Software engineer.
"xamfear@.comcast.net" wrote:
> Thanks for taking the time to reply Paul. The agent is running, and we
> know it runs fine since other jobs are run as the agent just fine, and
> in this case the other steps of the Job execute fine as well.
> Thanks
> Max
> Paul wrote:
> > look under the management folder in Enterprise manager, not IE as I specified
> > below.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Paul" wrote:
> >
> > > make sure that your sql server agent is running. Look under the management
> > > folder in IE and it should have a green arrow in front of it, if it had a red
> > > square it is not running.
> > > --
> > > Paul G
> > > Software engineer.
> > >
> > >
> > > "xamfear@.comcast.net" wrote:
> > >
> > > > I am having an issue with a dts package.
> > > > I am able to execute the package as myself from enterprise manager but
> > > > I recieve an error when running it as a scheduled job. I have read
> > > > http://support.microsoft.com/kb/269074/en-us and am either missing
> > > > something (highly likly) or it doesn't apply to my particular set of
> > > > circumstances.
> > > >
> > > > The dts task uses a "Text File (destination)" Object with a unc path in
> > > > its properties
> > > > \\remoteserver\d$\nested\folder\input.txt
> > > >
> > > > The job is owned by SA and is executed by our domains sql account
> > > > \\mydomain\sqlservice
> > > >
> > > > \\mydomain\sqlservice has been set up with identical permission as
> > > > \\mydomain\myaccount to \\remoteserver\d$\nested\folder\
> > > >
> > > > >From the header of the package logs
> > > > Executed as user:
> > > > MYDOMAIN\sqlservice.
> > > > ...Start: DTSStep_DTSExecuteSQLTask_1
> > > >
> > > > SQL Task 1 runs just fine (import routines which massage data from
> > > > \\anotherserver\inputdir)
> > > > Then as soon as it tries to export the file it fails.
> > > >
> > > > DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
> > > > (80004005)
> > > > Error string: Error opening datafile: Access is denied.
> > > > Error source: Microsoft Data Transformation Services Flat File Rowset
> > > > Provider
> > > > Help file: DTSFFile.hlp Help co...
> > > > Process Exit Code 1.
> > > > The step failed.
> > > >
> > > > Seems like a cut and dried case of permissions - but
> > > > \\MYDOMAIN\sqlservice has access to the location.
> > > >
> > > > ARRRG! Please advise.
> > > > Max
> > > >
> > > >
>|||That is a permissions error. Is the SQL Agent service
account also running under the domain account? The way you
have this set up, the SQL Agent service account would need
to be an administrator on the remote server - if it's not
then that's probably the issue.
Try creating a share on the remote server and give the SQL
Agent service account full permissions to this share. Then
reference the share you just created instead of the Admin
share you referenced using for the file location.
-Sue
On 29 Aug 2006 14:09:39 -0700, xamfear@.comcast.net wrote:
>I am having an issue with a dts package.
>I am able to execute the package as myself from enterprise manager but
>I recieve an error when running it as a scheduled job. I have read
>http://support.microsoft.com/kb/269074/en-us and am either missing
>something (highly likly) or it doesn't apply to my particular set of
>circumstances.
>The dts task uses a "Text File (destination)" Object with a unc path in
>its properties
>\\remoteserver\d$\nested\folder\input.txt
>The job is owned by SA and is executed by our domains sql account
>\\mydomain\sqlservice
>\\mydomain\sqlservice has been set up with identical permission as
>\\mydomain\myaccount to \\remoteserver\d$\nested\folder\
>>From the header of the package logs
>Executed as user:
> MYDOMAIN\sqlservice.
> ...Start: DTSStep_DTSExecuteSQLTask_1
>SQL Task 1 runs just fine (import routines which massage data from
>\\anotherserver\inputdir)
>Then as soon as it tries to export the file it fails.
> DTSRun OnError: DTSStep_DTSDataPumpTask_3, Error = -2147467259
>(80004005)
> Error string: Error opening datafile: Access is denied.
> Error source: Microsoft Data Transformation Services Flat File Rowset
>Provider
> Help file: DTSFFile.hlp Help co...
> Process Exit Code 1.
> The step failed.
>Seems like a cut and dried case of permissions - but
>\\MYDOMAIN\sqlservice has access to the location.
>ARRRG! Please advise.
>Max

Scheduled DTS not running

I created a DTS Local Package that should run on a specified time (ex. 9:00 AM) using EnterPrise Manager on my PC.

It is basically copying a file from our AS400 to the SQL server. It works fine if you execute it but the scheduler does not run at the specified time.

Am I missing anything here?

TIFOriginally posted by ARPRINCE
I created a DTS Local Package that should run on a specified time (ex. 9:00 AM) using EnterPrise Manager on my PC.

It is basically copying a file from our AS400 to the SQL server. It works fine if you execute it but the scheduler does not run at the specified time.

Am I missing anything here?

TIF

chk if SQL Agent is started|||Yup. The Agent is running. When I checked the jobs, I see an "X" on the DTS job I created and says that it failed. However, I can't see a log that gives me the exact reason why it failed.|||Check your Agent service account has permission on AS 400 server!|||When I configured my DTS, I entered the AS400 user credentials so I figured this is enough since when I execute my DTS, in works just fine. It's only when I use the schedule that it doesn't work.

How do you check anagent service account permission on a AS400? Sorry, I'm relatively new using this DTS thing.

Thanks|||can you just check sql agent error, see what it says!!
Agent right-click--Display error log.|||Don't forget that when you interactivly run a DTS package, it runs under your credentials. When SQLAgent runs it, it runs with the permissions given to SQLAgent. Maybe you have permissions to access the AS400 but SQLAgent does not??|||Originally posted by tomh53
Don't forget that when you interactivly run a DTS package, it runs under your credentials. When SQLAgent runs it, it runs with the permissions given to SQLAgent. Maybe you have permissions to access the AS400 but SQLAgent does not??

I see the error log but it does not show my any logs for yesterday and today. As a matter of fact, the last log date is 2/15/2004.|||Probably Agent configured to clear all jobhistory logs..
In anycase as tom said, look into SQLAgent service account has permission to connect AS400. When you run it manually it takes your credentials..when it runs under SqlAgent it looks for SqlAgent service account.|||Thanks for the TIPs. I will look into it more thoroughly.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.
Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.
|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.
|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the
job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure
that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Scheduled DB Backup Never Executed, Why? Why?

Howdy folks,
I am running win 2000 server + SP3 and SQL Server 7 with
SP3. I used Enterprise Manager to schedule weekly local
disk backup but it never executed. How do I know? I
browse throught the local disk, sql server log and could
not find any indications at all.
In Enterprise Manager->Management->Sql Server Log (no new
logs)
In Enterprise Manager->select the db->all task->backup db
1) On General Tab
Backup Portion -> DB Complete
Destinatin Portion -> Add and navigated to default
location, C:\MSSQL\BACKUP\AprilBackup.bak
Overwrite Portion -> overwrite existing media
Schedule -> recurring and entered the desinated day & hour
2) On Option Tab
I selected "Verify Backup upon completion"
I scheduled to run on Every Thursday at 4:00am but for the
past 4 weeks, no scheduled backup had ever executed.
Why? Can anyone help me, please.
Vito Corleone
President
Export & Import Oliver Oil Co.Vito,
Check if sqlagent is running.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.|||I'm sure you have verified this, but have you checked to make sure that the job is enabled. In EM go to Management - Sql Server Agent - Jobs. Make sure that the job in question has a yes in the enabled column.|||Hi,
As Dinesh posted.. Please check whether your "SQL Agent" service in SQL
Server machine is
running. If stopped "start" the service and verify whether the job gets
executed.
Incase if the service failed to start, go to Control Panel -- Services-- SQL
Agent Log ON window.. Re- enter the
OS user name and password (if it is not starting in Local system account).
Enter the same OS User you used to start MSSQL
Server service.This will probably solve your issue
Thanks
Hari
MCDBA
"Vito Corleone" <anonymous@.discussions.microsoft.com> wrote in message
news:13fa01c4265a$edae9410$a301280a@.phx.gbl...
> Howdy folks,
> I am running win 2000 server + SP3 and SQL Server 7 with
> SP3. I used Enterprise Manager to schedule weekly local
> disk backup but it never executed. How do I know? I
> browse throught the local disk, sql server log and could
> not find any indications at all.
> In Enterprise Manager->Management->Sql Server Log (no new
> logs)
> In Enterprise Manager->select the db->all task->backup db
> 1) On General Tab
> Backup Portion -> DB Complete
> Destinatin Portion -> Add and navigated to default
> location, C:\MSSQL\BACKUP\AprilBackup.bak
> Overwrite Portion -> overwrite existing media
> Schedule -> recurring and entered the desinated day & hour
> 2) On Option Tab
> I selected "Verify Backup upon completion"
> I scheduled to run on Every Thursday at 4:00am but for the
> past 4 weeks, no scheduled backup had ever executed.
> Why? Can anyone help me, please.
> Vito Corleone
> President
> Export & Import Oliver Oil Co.

Wednesday, March 7, 2012

Schedule package menu grayed out in EM

I tried to schedule a local package under Enterprise Manager\DTS\Local
package by right click local packages. However the Schedule package menu
grayed out. I used the domain login, which is SQL Server system
administrator role. This account is also in the administrators group of SQL
Server machine, and has log in as service and batch privilege. Moreover SQL
agent service is under this account.
Since SQL Server machine box itself does not install Enterprise Manager, I
add SQL Server registration from client machine, which login with above
domain account. Looks like I have all the privileges. I cannot figure out
why Schedule package menu is still grayed out. Please help. Thanks,
Charts
Hi Charts,
Thanks for your post.
From your descriptiosn, I understood Schedule Package menu is grayed out in
your SEM. If I have misunderstood your concern, please feel free to point
it out.
Based on my knowledge, please make sure SQL Agent is correctly started.
Would you please paste the SQL Server logs here? I understand the
information may be sensitive to you, my direct email address is
v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
click SEND as it's only for SPAM), you may send the file to me directly and
I will keep secure.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Mike,
I made sure SQL agent started and running. There are so many logs in event
viewer for SQLAgent$InstanceName, most of them are not relevant. SQL Server
machine itself does not have SEM, so I used other machines to register for
SQL Server. I have two other questions. 1) Am I able to install SEM in the
server machine without affecting the SQL Server activities? 2) How do I use
dtsrun utility to schedule a package? Can you give me an example for syntax
using pseudo SQL name? Thanks a lot for your help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your post.
> From your descriptiosn, I understood Schedule Package menu is grayed out in
> your SEM. If I have misunderstood your concern, please feel free to point
> it out.
> Based on my knowledge, please make sure SQL Agent is correctly started.
> Would you please paste the SQL Server logs here? I understand the
> information may be sensitive to you, my direct email address is
> v-mingqc@.online.microsoft.com (make sure to remove 'online.' before you
> click SEND as it's only for SPAM), you may send the file to me directly and
> I will keep secure.
> If you register this SQL Server in another machine, does "Schedule
> Package..." menu also disabled?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your prompt update.
For your questions[vbcol=seagreen]
Yes, SQL Server Enterprise Manager is the component of SQL Server Client
Tools, registering SQL Server instance with SEM won't affect SQL Server
activities.
Please register the SQL Server in a new machine and see whether it will
reproduce this issue on that new machine.
[vbcol=seagreen]
an[vbcol=seagreen]
Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
name>
If you want to schedule it, create a job and let it execute the command in
a regular time.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Mike,
It’s very helpful. For question 1) it’s not the issue registering SQL
Server instance. I don’t have SQL enterprise manager installed in the server
machine, and I wanted to install this tool without affecting server. I guess
I need to put SQL Server 2000 installation CD in and start install process.
Can you give me some instruction for safe installation since this is existing
server?
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your prompt update.
> For your questions
> Yes, SQL Server Enterprise Manager is the component of SQL Server Client
> Tools, registering SQL Server instance with SEM won't affect SQL Server
> activities.
> Please register the SQL Server in a new machine and see whether it will
> reproduce this issue on that new machine.
> an
> Here is a simple example: C:\> dtsrun /s <server name> /e /N <DTS package
> name>
> If you want to schedule it, create a job and let it execute the command in
> a regular time.
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/tec...rview/40010469
> Others: https://partner.microsoft.com/US/tec...pportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
Thanks for your update.
Based on my knowledge, if you install SQL Server in the machine, SQL Server
Client Tools will also be installed, so I am not very sure your scenario.
Would you please help me explain it clearly? More detailed descriptions, I
believe, will make us closer to the resolution.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Never mind Mike,
I found EM component in the server component installation. Thanks for your
help.
Charts
"Michael Cheng [MSFT]" wrote:

> Hi Charts,
> Thanks for your update.
> Based on my knowledge, if you install SQL Server in the machine, SQL Server
> Client Tools will also be installed, so I am not very sure your scenario.
> Would you please help me explain it clearly? More detailed descriptions, I
> believe, will make us closer to the resolution.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi Charts,
That's OK and let's go back to see why Schedule package menu grayed out.
If you register this SQL Server in another machine, does "Schedule
Package..." menu also disabled?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Schedule OSQL Job to send output to shared drive

quote:

> I'm trying to schedule a job in Enterprise Manager...the job is using osql

and I'm trying to send the output file to a shared drive on another server.

quote:

> Here's an example:
> osql -E -dmaster -Q"sp_who" -o\\servername\sharename\filename
> When I run this at a cmd prompt, the job works just fine, sending the

output file to the share. When I use the job scheduler in SQL Server, I get
the error: Cannot open output file - <filename>. No such file or directory.
I've confirmed the path I'm using is correct.

quote:

> Is the job scheduler just unable to write to a shared drive? Any

suggestions to work around this?

quote:

> Any input is greatly appreciated!
> Thanks,
> Jennifer

|||Jobs run under the permission of SQL AGent... make sure SQL Agent has the
correct permissions on the file directory.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Jennifer" <anonymous@.discussions.microsoft.com> wrote in message
news:7E0330E7-92F8-4F1A-B8CC-191FCBB40534@.microsoft.com...

quote:

> I'm trying to schedule a job in Enterprise Manager...the job is using osql

and I'm trying to send the output file to a shared drive on another server.

quote:

> Here's an example:
> osql -E -dmaster -Q"sp_who" -o\\servername\sharename\filename
> When I run this at a cmd prompt, the job works just fine, sending the

output file to the share. When I use the job scheduler in SQL Server, I get
the error: Cannot open output file - <filename>. No such file or directory.
I've confirmed the path I'm using is correct.

quote:

> Is the job scheduler just unable to write to a shared drive? Any

suggestions to work around this?

quote:

> Any input is greatly appreciated!
> Thanks,
> Jennifer

|||Yes, the server can see that share. If I run the exact syntax at a command
prompt, the job works fine. If I run the same syntax in the job scheduler,
I get the error "cannot open output file."
The SQL Server Agent on both servers is running under the same domain accoun
t, and that account is an administrator on both servers. Are there any othe
r permissions I need to check?|||What Windows user account were you logged in when you ran the osql command
at the command prompt? Were you using the same SQL Server Agent service
account?
After you have logged in using the same SQL Server Agent account, open a
command prompt and type
cmd>dir \\servername\sharename\filename
This will tell you whether the account can see the share.
Alternatively, you can also open a command prompt as follows:
cmd>runas /user:yourDomain\SQLAgentAccount cmd
and then test osql in that new command prompt.
Linchi Shea
linchi_shea@.NOSPAMml.com
"Jennifer" <anonymous@.discussions.microsoft.com> wrote in message
news:D1C109D1-F526-491F-B6BE-D08F47478B62@.microsoft.com...

quote:

> Yes, the server can see that share. If I run the exact syntax at a

command prompt, the job works fine. If I run the same syntax in the job
scheduler, I get the error "cannot open output file."

quote:

> The SQL Server Agent on both servers is running under the same domain

account, and that account is an administrator on both servers. Are there
any other permissions I need to check?|||Yes, I can see the shared drive from the cmd prompt. The problem is the job
scheduled through Enterprise Manager cannot see the shared drive.

Schedule OSQL Job to send output to shared drive

I'm trying to schedule a job in Enterprise Manager...the job is using osql and I'm trying to send the output file to a shared drive on another server.
Here's an example:
osql -E -dmaster -Q"sp_who" -o\\servername\sharename\filename
When I run this at a cmd prompt, the job works just fine, sending the output file to the share. When I use the job scheduler in SQL Server, I get the error: Cannot open output file - <filename>. No such file or directory. I've confirmed the path I'm using is correct.
Is the job scheduler just unable to write to a shared drive? Any suggestions to work around this?
Any input is greatly appreciated!
Thanks,
Jennifermaybe a silly question, but have you confirmed that the Server can in fact
see that particular share?
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Jennifer" <anonymous@.discussions.microsoft.com> wrote in message
news:7E0330E7-92F8-4F1A-B8CC-191FCBB40534@.microsoft.com...
> I'm trying to schedule a job in Enterprise Manager...the job is using osql
and I'm trying to send the output file to a shared drive on another server.
> Here's an example:
> osql -E -dmaster -Q"sp_who" -o\\servername\sharename\filename
> When I run this at a cmd prompt, the job works just fine, sending the
output file to the share. When I use the job scheduler in SQL Server, I get
the error: Cannot open output file - <filename>. No such file or directory.
I've confirmed the path I'm using is correct.
> Is the job scheduler just unable to write to a shared drive? Any
suggestions to work around this?
> Any input is greatly appreciated!
> Thanks,
> Jennifer|||Jobs run under the permission of SQL AGent... make sure SQL Agent has the
correct permissions on the file directory.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Jennifer" <anonymous@.discussions.microsoft.com> wrote in message
news:7E0330E7-92F8-4F1A-B8CC-191FCBB40534@.microsoft.com...
> I'm trying to schedule a job in Enterprise Manager...the job is using osql
and I'm trying to send the output file to a shared drive on another server.
> Here's an example:
> osql -E -dmaster -Q"sp_who" -o\\servername\sharename\filename
> When I run this at a cmd prompt, the job works just fine, sending the
output file to the share. When I use the job scheduler in SQL Server, I get
the error: Cannot open output file - <filename>. No such file or directory.
I've confirmed the path I'm using is correct.
> Is the job scheduler just unable to write to a shared drive? Any
suggestions to work around this?
> Any input is greatly appreciated!
> Thanks,
> Jennifer|||Yes, the server can see that share. If I run the exact syntax at a command prompt, the job works fine. If I run the same syntax in the job scheduler, I get the error "cannot open output file."
The SQL Server Agent on both servers is running under the same domain account, and that account is an administrator on both servers. Are there any other permissions I need to check?|||What Windows user account were you logged in when you ran the osql command
at the command prompt? Were you using the same SQL Server Agent service
account?
After you have logged in using the same SQL Server Agent account, open a
command prompt and type
cmd>dir \\servername\sharename\filename
This will tell you whether the account can see the share.
Alternatively, you can also open a command prompt as follows:
cmd>runas /user:yourDomain\SQLAgentAccount cmd
and then test osql in that new command prompt.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Jennifer" <anonymous@.discussions.microsoft.com> wrote in message
news:D1C109D1-F526-491F-B6BE-D08F47478B62@.microsoft.com...
> Yes, the server can see that share. If I run the exact syntax at a
command prompt, the job works fine. If I run the same syntax in the job
scheduler, I get the error "cannot open output file."
> The SQL Server Agent on both servers is running under the same domain
account, and that account is an administrator on both servers. Are there
any other permissions I need to check?|||Yes, I can see the shared drive from the cmd prompt. The problem is the job scheduled through Enterprise Manager cannot see the shared drive.

Schedule MSDE Backup - HELP!!

Can anyone give me instructions on how to SCHEDULE backups for MSDE2000?
Enterprise manager will do backups manually but the scheduled ones don't
keep the file location of the backup. If you enter a maintenance plan and
then go back to it in properties, the path for the backup is gone and you
can't re-enter it. My developer had issues when he tried to code a backup
instead of using Enterprise Mgr. Right now I manually back them up but I'd
like to schedule something once a day and then put that whole backup
directory on tape at night. I've seen some posts from other on the web who
have the same issue but have been unable to find anyone who found a fix.
Best Wishes,
Steve
hi,
"bozo" <bozo@.bozosplace.com> ha scritto nel messaggio
news:10nc3d57n55lc0d@.corp.supernews.com
> Can anyone give me instructions on how to SCHEDULE backups for
> MSDE2000? Enterprise manager will do backups manually but the
> scheduled ones don't keep the file location of the backup. If you
> enter a maintenance plan and then go back to it in properties, the
> path for the backup is gone and you can't re-enter it. My developer
> had issues when he tried to code a backup instead of using Enterprise
> Mgr. Right now I manually back them up but I'd like to schedule
> something once a day and then put that whole backup directory on tape
> at night. I've seen some posts from other on the web who have the
> same issue but have been unable to find anyone who found a fix.
I do not use maintenance plans, but usually use jobs to do it..
you have to code using sp_add_job msdb system stored procedure, and adding
job steps and job schedules...
the master job step will then be a Transact-SQL subsystem step, where you
store the actual BACKUP DATABASE... statement(s)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Bozo,
There's a tool on our site (MSDE Manager) that will let you do this. It's
free for personal use.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"bozo" <bozo@.bozosplace.com> wrote in message
news:10nc3d57n55lc0d@.corp.supernews.com...
> Can anyone give me instructions on how to SCHEDULE backups for MSDE2000?
> Enterprise manager will do backups manually but the scheduled ones don't
> keep the file location of the backup. If you enter a maintenance plan and
> then go back to it in properties, the path for the backup is gone and you
> can't re-enter it. My developer had issues when he tried to code a backup
> instead of using Enterprise Mgr. Right now I manually back them up but
> I'd
> like to schedule something once a day and then put that whole backup
> directory on tape at night. I've seen some posts from other on the web
> who
> have the same issue but have been unable to find anyone who found a fix.
> --
> Best Wishes,
> Steve
>

Tuesday, February 21, 2012

Schedule Backup issue using Enterprise Manager

I have set up EM to back up several databases on a machine running Win2k
Advanced Server and SQL Server 2000 SP2. On each db, I right click and
created a backup task and set a reoccurring scheduled time for daily back
ups. What's weird and someone frustrating is that the tasks ALWAYS append
existing data which makes the backups unnecessarily large and the scheduled
time never sticks. I'll go in a click Overwrite Existing Data and set the
back up time each day and it never says these changes. I've even tried to
remove the task(s) and create new ones from scratch and it won't let me
remove the old ones. Each day, it appends the existing data and the
scheduled time is never there (even though the auto backups do occur...not
sure why).
So...each and every day, I have to go and manually backup each db. Not a
huge deal but a bit frustrating since EM should do this for me. Any ideas?
Is this a known issue?
TIA!
-SIf you use Enterprise Manager and the Backup Database task
by right clicking on a database, this will create a job
named something like YourDatabase backup
The job will have a T-SQL step that will execute the T-SQL
backup statement that was generated when you scheduled the
task. If you need to make changes, you need to modify the
job rather than trying to go back in through the task part
of Enterprise Manager.
You can modify the schedule from the schedule tab of the
job.
If the job was initially created to append, the backup
command in the job step with include WITH NOINIT. You can
change this to WITH INIT if you want to overwrite the
backups. You can find more information on the BACKUP
DATABASE statement that is generated and it's options in
books online under backup.
-Sue
On Thu, 13 Jan 2005 09:41:29 -0500, "D. Shane Fowlkes"
<shanefowlkes@.h-o-t-m-a-i-l.com> wrote:
>I have set up EM to back up several databases on a machine running Win2k
>Advanced Server and SQL Server 2000 SP2. On each db, I right click and
>created a backup task and set a reoccurring scheduled time for daily back
>ups. What's weird and someone frustrating is that the tasks ALWAYS append
>existing data which makes the backups unnecessarily large and the scheduled
>time never sticks. I'll go in a click Overwrite Existing Data and set the
>back up time each day and it never says these changes. I've even tried to
>remove the task(s) and create new ones from scratch and it won't let me
>remove the old ones. Each day, it appends the existing data and the
>scheduled time is never there (even though the auto backups do occur...not
>sure why).
>So...each and every day, I have to go and manually backup each db. Not a
>huge deal but a bit frustrating since EM should do this for me. Any ideas?
>Is this a known issue?
>TIA!
>-S
>

Wednesday, March 28, 2012

Scheduling DTS Package using a stored procedure problem

Monday, March 26, 2012

Scheduling a Report

scheduling a query

scheduling a query

scheduling a query

Friday, March 23, 2012

Scheduling a DTS package without admin privileges.

Scheduling a DTS package

Wednesday, March 21, 2012

Scheduled reports never run

Tuesday, March 20, 2012

Scheduled Job Not Working

Monday, March 12, 2012

Scheduled Job Error

Scheduled Job Error

Scheduled DTS not running

Scheduled DB Backup Never Executed, Why? Why?

Scheduled DB Backup Never Executed, Why? Why?

Scheduled DB Backup Never Executed, Why? Why?

Wednesday, March 7, 2012

Schedule package menu grayed out in EM

Schedule OSQL Job to send output to shared drive

Schedule OSQL Job to send output to shared drive

Schedule MSDE Backup - HELP!!

Tuesday, February 21, 2012

Schedule Backup issue using Enterprise Manager

T-SQL Script

Blog Archive

About Me