Where can I find an english translation of the values in fields ReccurrenceType, State, Daysofweek, and Type in the Schedule table of the ReportServer database?
Example what does it mean when RecurrenceType is equal to 2, or equal to 4?
Thanks
I have an application that has a dropdown in which, I want a users most popular choices (from history) to be on top. This is easily done via a query however the query is too slow, after be optimized. I'd like to have create a table that contains each users most popular selection, and then just update it nightly. How can I schedule some SQL code to run nightly?
View 1 Replies View RelatedI have a table right now, that gives when an event was done in a date time (eg. Event done Jan 1, 2014, event 2 done Jan 2, 2014).
What is a feasible way to make a second table to join on this date time which provides the type of worker (eg. part time, full time, volumteer, etc) without making a table with every day, hour and minute as a separate row?
For example, a test was done on Jan 1, 2014 at 1pm, in table A. I was thinking my second table would list every date and time and fill in what type of worker was on at that minute/time. Then I would left outer join with my first table, so the end result would be Event A was done Jan 1, 1pm, therefore it was a: Volunteer worker. Event B was done Jan 1, 2pm, therefore it was a : Full time worker.
But I realize that it is not feasible to write a table with every date/time available to accommodate all the different types of shifts.
hi friends,
i have SSIS packages and i want them execure from table values...
table ETLJOBS
PackageID 1,2,3
Name
FrequencyOF Run 30,60,90 (Mint)
StartTime
EndTime
.....
....
how can i use table values and Execure Package.
here my package frequency can be change in future so i want to make my code generic.
thx for reading my question.
Hello all,
I hope someone can help me with a big problem... I'm using Citrix Resource Management Services with a SQL 2000 database. Their are 15 citrix servers which are all reporting to the SQL database.
The database is expanding very quickly and is becoming slower and slower.
My question is: I want to schedule a purge of old records on a friday afternoon, like this:
WEEK 1 - MON / FRI
WEEK 2 - MON / FRI (Friday's purge records week1)
WEEK 3 - MON / FRI (Friday's purge records week2)
etc...
Is this possible? if yes how do i do this !??!
Thank you very much for any info!!
Daan
The only way the job success is if I select the option add rows wich is copying all rows even the ones that are already there, I tried to drop amd recreate the table option but i just dosn't run that way, help please..
View 1 Replies View Related
I couldn't find any tutorials/articles on integrating a SharePoint web service call with an SSIS package
I need to schedule a web service to truncate and populate SharePoint Lists (2007 & 2003) from a SQL Server 2005 table.
I guess I'm just ignorant about integrating web services with SSIS. How do I make a call to the web service through my SSIS package? (script task?)
Any links to articles/tutorials or pointers would be apreciated.
http://msdn2.microsoft.com/en-us/library/aa177009(SQL.80).aspx
i need to schedule asp code execution using SQL Stored Procedure ...im not allowed to connect using Enterprise Manager is it possible in ASP and in case how?
Hi all,
I want to make a job schedular in SQLServer 2005. That is i want to send email to users daily at 12:00 PM.
how can i schedule using SQLServer Agent in SQLServer 2005. And i want to filter the users from user table. Please help me
Thanks!
Hello,
I would like to schedule a job every 30 sec. The min time in job schedule is it allows 1 min. Is there a way I could run the job every 30 sec.
Thanks
Moin
How Do I schedule Sql server Jobs in interval of Seconds in place on minute/Hours? Is it possible in Sql Server?
Thanks..
Hi
I have lots of DTS Packages that I am running manually daily and I am trying to create schedule all of those and all of them are failing. Some of those are accross domians,but the owner on both domains have same userId and password.
Any Idea why this is failing would be really helpful
thanks in Advance
taapas
Hi
I would like to import data via DTS from one db to another to run every half hour.What would be the easier way to do this?Should I setup a job to run every half hour?
If anyone could help with some suggestions , it would be appreciated.
When I try to schedule a DTS package which is an EXE it doesn't run.
If I just run the DTS package it works fine.
I have checked the permissions of the DTS scheduled package and made sure
it had proper rights. SQL Server Services were started with the proper security rights.
When I schedule the DTS package, it is being done on the Server, and not a workstation.
Any ideas on why it will not run?...
Also, How do you schedule and EXE under SQL Server Agent Jobs.
Even when I schedule an EXE that is not a DTS package it doesn't run...
Thanks,
Daniel
Can any one tell me how to schedule a job using sql query
View 2 Replies View Relatedis there a way to make a job schedule that running store procedure for msql express ?
i'd like to make a time counter that will update every minute.
thanks
I have almost completed a full project by myself which is soooo exciting. The last thing I need to do is schedule a job to run the query on a specific day and time. So how do I do this? It asks me for a command and I am not sure what I am supposed to enter in here.
The Yak Village Idiot
How could I get an sp to run every morning at 1.00am. It would delete empty entries from a sql database.
Thx
Im trying to schedule a DTS package that I have created. When I right click on the package in Enterprise Manager and click on "Schedule" I get the options to set up the job to run on a schedule.
I fill out the time and click "OK". But when I immediately right click on the package again, all my settings are gone, and the defaults are back in place.
How do I know if the package will run- or if it did run?
I would actually prefer to run the job from a command line using a Scheduled Task... What would the syntax be? My DTS Local Package is named "IMPORT_DAILY_UPDATE"
Thanks
on ss2k5, how do you find out if sql job schedule is enable using QA?
http://www.sqlserverstudy.com
How is it possible to schedule a SSIS package to run at a certain time please?
View 13 Replies View RelatedHi all,
I create a new in SQL Server Agent. However, When I click start Job at step, the first step start immediately,not the schedule I set. So How can do I make it to run at the schedule time?
Thank you
I have MS SQL installed on my workstation at work. I am trying to use DTS to export data from our local network that uses a Pervasive DB to our web server that is hosted with another company.
If I go in and manually execute the DTS package from my workstation, it send the data to the web server.
If I try to schedule the DTS Package to automatically send the data, it fails. SQL Server Agent is running on my workstation and on the web server.
Is what I am trying to do possible? What am I doing wrong?
Kinda general question -but before I embark on my own design I thought I ask around. . .
What I want to design is database representation of a schedule of a roster. For instance a school roster. I hope I am not being too general here.
I want to create a job to run once a week in sql server agent jobs. Setting up the the job to run is no problem. I want the job to run a sql statement that will retrieve sql. I then want the records to be inserted in a txt file. What is the best way to accomplish this.
View 2 Replies View Relatedanyone ever encountered this....i have a package which will execute fine manually but when i try to schedule it, it fails immediately (within the first second).i can even right click on the scheduled package and do "generate sql script" and then run that script and again, no problem. it just will NOT schedule.any ideas?
View 3 Replies View RelatedHi All
I'm having problems scheduling a DTS package.
The server is SQL 7 sp2 running on NT4 sp5. The only other twist is that it's at a remote site that I connect to via NT Dial-up.
When I choose the 'Schedule Package...' menu option I get the normal dialog to set frequency etc... but the job isn't created.
Any guidence at all would be most appreciated.
Thanks
Phill
I create DTS package and when I want to schedule the package an error occures. The message says :
Microsoft SQL-DMO
Connection user failure (null)
Non associate to a secured SQL server link
Do you know what happened ?
Hello and thanks for reading my post...
I have a DTS package that I can execute manually all I want, no problem.
However, when I try to schedule the package to run as a job, it error when it tries to connect to my remote database, giving me comments about the ODBC driver (which is installed correctly).
My best guess is that when I run it manually, it running under my userid/password (NT authentication), but when it runs as a job, it is using the SQL Agent, which has a different level of authority somehow.
This may be a no-brainer, but I've looked at everything I know of.
Please help!
is it posible to change a file name usinging schedule task??
I used this syntax
Exec xp_cmdshell "REN
E:Elsie_DB_db_dump*.* E:Elsie_DB"
Is there another way of doing it??
Hi,
I have 2 jobs schedule to run after every alternate hour. Job A runs at 1 am, 3 am, 5 am etc. and job B runs at 2 am, 4 am , 6 am.
If job A is still running I would like Job B not to start at the scheduled time. How can I achieve this?
Thanks in Advance .... j
Hello there,
Is there any way to schedule SQL Databases restore (maybe from a command script) on Windows NT4,
SQL server 6.5 sce pack 5a ?
Thanks!
Regards,
Rachel
Does anyone know of any way to schedule a task using only transact sql, or is using Enterprise Mgr the only way to do this?
View 1 Replies View Related