Database Jobs Articles
Aug 7, 2007Hello Friends
Can any body tell about the database jobs. what are the database jobs and how do they work.
If any body have any link relevant to it please send me as early as possible.
Thanks
SARB
ADVERTISEMENT
Creating Database To Save Ratings Of Articles Given By Users
Aug 11, 2013I would like to create a database & save to that data base the ratings of articles that are given by the users.
(I want to create a recommendation system.)
I am using joomla! How do I do this ?
Designing Database For Jobs Portal
May 27, 2006Hi...
I am making a online job portal....for dat i need to make a gud database.
wud anybody be kind enuf to provide or tell me how to make a good database design...
thnx..
Creating Jobs On Mirroring Database
Apr 22, 2008
Hello,
We have some jobs that are running on the principle database. I am planning to create those jobs in the mirror database also, so that when it gets failover it will automatically run those jobs. Here is my question, Is there any way we could create the jobs on mirror database also and say not to run (exit) if the database is in mirror role by writing some scripts or by selecting any options? Please let me know. Thanks!
Execute Access Database As SQL Server Jobs
Nov 21, 2006Hi While we are migrating Access Database to SQL Server, we would like to keep the Access Database running on schedule in steps until we migrate everything in SQL Server. I have created a SQL Server Job under “Operating System Command (CmdExec)� and in command, pointed where the Access Database is located.
I have created this job as an Admin, so admin has full rights. But when I run this job it does not execute Access Database and gives an error. Following (under dotted line) is the error from Event Log.…………………………………………………..Event Type: WarningEvent Source: SQLSERVERAGENTEvent Category: Job Engine Event ID: 208Date: 11/21/2006Time: 9:15:53 AMUser: N/AComputer: SqlServer01Description:SQL Server Scheduled Job 'Test' (0x86BC5A6881DF1E48BF270E6513B2A0DD) - Status: Failed - Invoked on: 2006-11-21 09:15:51 - Message: The job failed. The Job was invoked by User admin. The last step to run was step 1 (test).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.……………………………………………………
I had replaced access database with some exe file then ran the job. Job ran fine. Why SQL Server job is not able to execute Access Database?
Note: SQL Server has Access Database installed.
Please let me know. I know this is not a very common situation but this is also an option available to utilize.
ThanksRashid
How To Disable/enable Jobs For Database That Has Failed Over
Nov 22, 2006Hi,
I currently have serverA importing data from an AS400 oledb connection and serverB on hot-standby as a mirror. The data import is being performed via an SSIS scheduled job.
I've yet to implement any solution in the following case:
If the database on serverA fails, it will failover to the mirror. But the jobs will still be on serverA. Ideally, I'm assuming the jobs should not run on serverB since it will be attempting to update the mirrored database. So, I am wondering if both servers can have identical copies of SSIS packages and jobs and simply (?) enable or disable them based on which server will be hosting the principal database.
Is there any solution where the jobs can automatically be disabled on the server with the mirrored database and enabled on the principal database depending on its status?
Moving Reporting Services Database And Jobs To Another Server
Mar 10, 2008Hi
I am new to the sql server, we need to move the database from one server to another from developer's edition to standard edition of sql server 2005. it has the reproting services and lot of reporting service jobs are running on the server now. we need to move all those jobs also to the new server. could some body help me on how to move the database and reporting services jobs to the another server. Thanks!
Query Find A List Of All The Jobs In A SQL 2005 Database
Apr 22, 2008
Hi,
I was wondering if there was a SQL query I could run that would list all the current jobs in a SQL 2005 database? I would like to check to ensure a job exists before I call it, but was having trouble finding a way to determine if it existed.
Thanks for any advice!
-Flea#
How To Schedule A Database Backup In SQL Server Agent Jobs?
Jan 7, 2008I want to schedule a database backup using SQL Server Agent Jobs how can i do this?
View 1 Replies View RelatedArticles Default
May 11, 2006hi all,
I was trying to set the articles to
"delete data in the existing table that matches the row filter"
in the publications "article>articles>table articles>snapshot" of
the publication
but everytime i reopen that property tab
the publication restore to the
default setting of "drop exisiting table and recreate it"
i"m using sql server 2000. snapshot replication--
thanks,
------------------------------------
joey
Books, Articles About ETL
Apr 22, 2008
Hello,
maybe anyone knows good books or articles about ETL, ETL processes, ETL optimization ?
If you know where i can download - post a link
Thanks
Way To List All Articles
Jun 19, 2007Is there a way in T-SQL to programmatically list all the articles? What I'm wanting to do is grab these articles and run this SP:
EXEC sp_publication_validation 'people', @rowcount_only=2, @full_or_fast=0
For each aritcle/publication, but I need a way to programmatically calculate the 'people' article in this case and pass that information along to the sp_publication_validation SP.
Is there a way, perhaps in system tables or system SP to accomplish this?
Thanks,
Phil
Where To Place Articles
May 30, 2006I have a design that includes articles that will be searched. Obviously its too slow to put them into fields, and impossible because some have photos or are otherwise html documents. So I want to put pointers to their location.
Two questions. For each deployment, both desktop and web, where is the best place to put the articles. In any folder, or only in an iis virtual folder?
dennist685
Storing Articles In SQL Server
Oct 25, 2007Hello Everyonen and thanks for your help in advance. I am developing a conetnet management system to allow for the storage of articles within a SQL Server 2000 database. I am using FreeTextBox as the editor for users to enter articles. I ahve two questions. First, many of the articles are quite lengthy and including HTML formatting go well beyond 8000 characters. How should I go about storing these articles? Should I use a TEXT datatype, or perhaps split the data into more than one row. This leads to my second quuestion. Many sites that display article type data break the artilce into multiple pages with page numbers or next links to page back and forth. I am not sure hot to go about implmeneting this. Any help on this topic would be greatly appreciated. Thanks.
View 3 Replies View RelatedArticles On VSS && MSSQL Server - ??
Jan 11, 2004Hi every1,
Does anyone know where i would be able to find good articles on this subject:
-Best Practices (Logical - planning & Physical) in Setting up Database Projects for MSSQL Server 2000 with Visual Source Safe 6.0
*It would also be helpful if articles take replicated environments into consideration.
thankyou
Where I Can Get Good Articles On Indexes ?
Nov 4, 2006Hi
where i can get good articles on indexes ?
Replication Not Creating Articles
Aug 13, 2015I'm new to replication and set up a Snapshot Replication on the tables in my sample database. Â Everything seemed to work (database created on Subscriber instance, jobs set up, etc) but the articles (tables) are not being created in the subscriber's database. Â
I can see the files created in the folder but I don't see the tables or the data. Â Also, I confirmed that the articles are checked so they should be included.
How To Monitor Failed Sql Server 2005 Jobs When Database Mail Is Disabled
Sep 14, 2007
We have our SQL Server 2005 hosted at a datacenter and have only SS Management Studio access (no term serv, no event log, etc.). Also, our hosting company has disabled the Database Mail feature. We have over 60 jobs running on a minute/hourly/daily basis that are critical for our business. It is super important for us to know if and when a job failed.
Given this scenario, how do you suggest we implement monitoring/notification of failed jobs?
Related Articles Stored Procedure
Mar 12, 2008I have a page which loads an article based on an ID, what i want to do now is when the article loads there will be a repeater control which holds headlines of related articles in it. My problem is how can i achieve this in terms of passing through the articleCategoryID to the stored procedure "stream_RelatedArticles".
This is my stored procedure that loads the initial article;
ALTER PROCEDURE [dbo].[stream_Articles]
as
SELECT TOP 5 articleID, articleTitle,articleDescription, articleAuthor,articleDatePublished,articleBody from Articles ORDER BY articleDatePublished
And this is the page_load;if (!IsPostBack)
{string strID = Request.QueryString["id"];
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString);SqlCommand command = new SqlCommand("stream_ArticlesByID", conn);
command.Parameters.Add("@articleID", SqlDbType.Int).Value = Request.QueryString["id"];command.CommandType = CommandType.StoredProcedure;
conn.Open();SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
ArticleList1.DataSource = reader;
ArticleList1.DataBind();
reader.Close();
}
And here is my related article stored procedure;ALTER PROCEDURE [dbo].[stream_RelatedArticles]@articleCategoryID INT
as
SELECT articleID,articleCategoryID, articleTitle,articleDescription, articleAuthor,articleDatePublished,articleBody from Articles
WHERE articleCategoryID = @articleCategoryID
Articles In More Than One Category - How To Organize Tables?
Jun 10, 2005Greetings,I have one table, named Article, and one table name Category.The problem is, one Article could be in just one or in several categories.What is the best way to connect data between Article and Category according to fast search performance?I have several ideas:1. To have third cross table Article_Category with fields Article_ID and Category_ID, and search Article_Category table 2. To have several INTEGER columns in Article table (like Category_ID1, Category_ID2,..) and search those columns3. Add one VARCHAR field in Article table where I could write Category ID's delimited by some character (e.g. by comma), and do text search in only that column.What is recommended for solving problems like this?
View 7 Replies View RelatedSnapshot Replication - Adding Articles
Mar 4, 2004Hey All - Another replication question:
Using VBScript in an ActiveX module of a DTS package...
Anyone have an idea how to add ALL articles to a Subscription.
The only way I can figure it is to load an array from sysobjects, then run sp_addarticle on each one.
Thanks for your help
RobbieD
SLQ Express And MS Access Comparative Articles
Dec 12, 2005Guys,
Do you have articles on this? this is for my reference.
thanks!
Adding A Article Causes ALL Articles To Be Refreshed
Sep 5, 2007
I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time.
This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped.
Has that functionality changed from 2000 to 2005? Am I not doing something right?
Thanks,
Amir
Problem With Publication Articles Being Deleted
Sep 15, 2006I wonder if anyone can advise, I currently have a replication set to 5 offices. Which has been working fine for some 18 months+, then the replication dropped out. When I looked in the publisher it had lost all its articles and would not allow me to add back in. I deleted the publication and recreated it and then after creating a new snapshot starting rolling back out to the various locations, and one of the locations failed and again all the articles where lost. I deleted and rebuilt the database at that office and went through the same routine again, only for it to happen again, the issue being that now errors where produced!!!.
So at present I have the publication and all the subscriptions running apart from this one office.
Has anyone had this before, or any ideas. I have run a full virus scan just in case and it was fine.
SQL 2012 :: Database Mail - Test Email Works But Jobs Won't Send Out Notifications
Oct 19, 2015I am trying to send out notifications when jobs complete (fail or succeed). I have database mail working fine on my DEV server, but I am having issues with it on my PROD server. I am currently having people look into if McAfee may be blocking it.
I am able to send out a test email from SSMS>Management>Database Mail, but when I set a Notification for a job, the job will complete and in the history, it will say "NOTE: Failed to notify 'User' via email."
I have created an Operator and set up Profiles and Accounts, just as I did on my DEV server.
SQL 2005 How To Change @conflict_retention For Articles Already Published
Dec 19, 2005Hello,
I have some articles already published and would like to change some of the articles default @conflict_retention of 14 days to 45 days. How can I accomplish this via t-sql? Thanks.
John
Select Statement For Retriving The Articles Aacording To The Week.
May 20, 2008 Dear Friends,
Hi I am having a problem while showing Products from SQL
Server database. Exactly I have a table named Products which has some Products
posted by admin I want to show some latest Products on my default page
based on DateTime which are displayed like show last week articles,show last two weeks articles etc on button click I written my SQL query like: searchquery = "select * from Prducts where Date between '" + System.DateTime.Now.AddDays(-7).ToShortDateString() + "' and '" + System.DateTime.Now.AddDays(-1).AddHours(23).AddMinutes(59).AddSeconds(29).ToShortDateString() + "'"; If any body knows plz help me
How To Select All Articles Form A Category Without An Article That Is Selected?
Jun 7, 2004Hello,
i want to Select all articles form a category without an article that is selected.
Thanx a lot !
SQL 2012 :: Transactional Replication - How To Remove Orphaned Articles
Jan 27, 2015We are runnning on SQL Server 2012 SP1 + CU9.
I have found some articles with no publication in our transactional replication.
For example, running this:
select p.publication,
a.publication_id,
a.article
from dbo.MSArticles as a
left outer join dbo.MSpublications as p
on a.publication_id = p.publication_id
shows this:
NULL1org_Community
NULL3org_Community
Purchasing to EDW5org_Community
NULL1org_Division
NULL3org_Division
Purchasing to EDW5org_Division
How can I get rid of the articles that are not part of a publication?
I can't use sp_droparticle because it requires a publication which these articles do not have.
SQL Server Admin 2014 :: Articles Not Being Applied To The Subscriber
Jul 21, 2015I have been adding a lot of Articles for Publication.
They make it to the distributer but they do not make it to the subscriber.
If I add articles before the previous batch of articles get applied to the subscriber could that cause a problem and for replication to become out of sync?
It is a pull transactional replication.
I have had to generate a snapshot for the problem to go away but it keeps happening.
Fortunately it is not in production yet.
[URL]
Good Source (books, Articles) For Complex Queries?
Jun 9, 2008Hi All -
Any recommendations for good advanced t-sql books/articles? I find myself involved with writing increasingly more complex queries and after spending a few hours on some, and then searching on this site for potential answers/help, I am wondering if there might be some good books on creating more advanced/complex t-sql for real world scenarios.
Thanks
- will
Can A Log Shipping Destination DB Be Used As The Source For Transactional Replication Articles?
Aug 6, 2007Hello,
My company is moving to a SQL Server-based packaged application early next year. We€™re planning our SQL Server architecture but have some questions that I can€™t readily find answers for. I€™m hoping someone here can point me in the right direction.
We have three servers, I€™ll call them A, B, and C. We want to duplicate all changes to certain databases on server A to server B, then duplicate changes to selected databases and tables on server B to server C.
Ideally we€™d run SQL Server 2005 Enterprise Edition on all three servers, but the packaged application vendor does not support SQL Server 2005 yet, only SQL Server 2000. Our license agreement with them does not allow us to use replication on server A. We€™re free to do whatever we want on our other SQL Servers, but server A must sit alone, untouched, like a monolith on a far-away moon. (I€™m lobbying to have the server named Tycho, or TMA2.) Stranger still, they€™re OK with log shipping from server A to other servers. We€™ve tried to explain that replication and log shipping are both core function built into SQL Server, and that if one is acceptable, then both should be. Their fear is that replication could cause performance and stability problems, and to eliminate this possibility they€™re ruling out replication on server A.
Given these constraints we€™re resigned to using SQL Server 2000 Enterprise Edition on servers A and B, and SQL Server 2005 Enterprise Edition on server C. We plan on periodically shipping logs from server A to server B and applying them at server B.
We€™d like to know if it is possible to also use transactional replication on server B to duplicate changes from server B to server C. I€™ve used log shipping and replication in the past, but never at the same time. My understanding is that a database goes into recovery mode while a transaction log is being applied and that any user changes to the database after the log has been applied will cause later log applications to fail. The scripts I€™ve seen that are used to apply the transaction logs put the database into single user mode after the log has been applied to prevent this.
This raises a few questions:
If we try to RESTORE a log to a database being used as a source for transactional replication articles, will the RESTORE fail? Or will the RESTORE start and break the transactional replication? I€™ll test this on my own, but it€™d be nice to know if anyone has already experienced this.
Is it possible for us to have a database in read-only mode serve as the source for transactional replication articles? (I can€™t imagine why not, ever though it seems counter-intuitive - why would you want to replicate transactions from a database that has no transactions?)
If the answer to number two is yes, can we suspend transactional replication on a database, RESTORE a log to the database, put the database into read-only mode after the RESTORE, and restart the replication on the database?
Thanks in advance for sharing your wisdom, everyone!
--
Thomas C. Mueller
The Maximum Number Of Articles Allowed In A Merge Publication Is 246.
Jun 4, 2007Has anyone had problems with this limitation before or could explain to me what the purpose of this limit is for? It obviously does allow you to publish more than 246 (we have been publishing more than 700 for years). Is this new with SQL 2005? Is my publication going to stop one day and tell me there are too many articles?
Thanks in advance.
Martin