March 5, 2011 at 4:42 am
I have a table in which i am keeping members record in binary tree concept like multi level marketing binary tree concept...i want to check members status daily at night by their downline tree member count(child member count)..i dont have sql server agent to use job to schedule.so i want to use service broker..so how can i activate the procedure daily at night to count child members and store it to any table to track thier status.i have procedure to count and all information but i dont have that event to call that procedure....
please help me and do the needful.
'
Thanks & Regards
Vritaz
March 5, 2011 at 5:16 am
Im a little confused as to your question,
Do you already know how to use service broker , and asking how to queue an event at a certain time ? Use sqlagent to pop a message onto the queue.
Or are you asking how to use service broker.
March 5, 2011 at 9:00 am
I dont have full version of sqlserver.In my web hosting plan i have express edition so i cant use sql server agent.so i searched about service broker.so how can i use it in the replacement of jobs .........please suggest me .....
March 5, 2011 at 9:28 am
Service broker is not a replacement for sql agent.
Do you have access to the "AT" scheduler command ?
March 5, 2011 at 9:50 am
i dont know about 'AT' schedular command
March 5, 2011 at 9:53 am
is it possible in sql server express edition to execute any stored procedure at particular time like backup databse daily at night 12.00 ......
March 5, 2011 at 12:32 pm
Try the AT Command Scheduler .
March 5, 2011 at 1:19 pm
As a side note to what Dave offered, which is accurate, Service Broker is only available in Express so it can be connected to a Standard or Enterprise edition. It doesn't behave itself independently in Express.
From here:
http://msdn.microsoft.com/en-us/library/ms165704(v=sql.90).aspx
Microsoft SQL Server 2005 Express Edition (SQL Server Express) database engine supports Service Broker only with a different edition of SQL Server 2005, such as Workgroup, Enterprise or Developer edition. Service Broker functionality is not supported between two editions of SQL Server Express.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 7, 2011 at 4:30 pm
vritaz09 (3/5/2011)
I dont have full version of sqlserver.In my web hosting plan i have express edition so i cant use sql server agent.so i searched about service broker.so how can i use it in the replacement of jobs .........please suggest me .....
Given that your in a Web Hosting environment and don't have SQL Agent available to you I doubt you have access to the AT scheduler which is an OS-level scheduler.
If you have permissions to create stored procedures in master db and rights to execute sp_procoption you could:
1. Create a proc in the master database that uses a WHILE loop containing a WAITFOR TIME command to execute code once per day.
2. Use sp_procoption to set the startup option on the proc so it executes whenever the SQL Server instance starts up. Here is a good tutorial on that: http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply