Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can Business Alerts be used to run Queries to insert the data in the Tables or update Tables ?

1 view
Skip to first unread message

Viol-8-r

unread,
Jan 6, 2010, 1:59:04 PM1/6/10
to
Hello people,
 
I was wondering if it is possible to run a SQL script through Business Alerts in GP. what I mean to say is that if I need to insert record from one table to another table I can copy that script and it will run at scheduled time ?
Regards,
 

Dencio

unread,
Jan 6, 2010, 4:25:01 PM1/6/10
to
Hi,

Business Alerts in GP is for notification only. The way you descrived your
data manipulation requirement is thru SQL triggers. This trigger can be set
from your source table (based on insert, update events) and execute a DML
(insert script) into the destination table. However, this will compromise
the integrity of your data if not properly planned and executed.

Hope this helps!

Cheers,

Dennis Araullo. MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator

Viol-8-r

unread,
Jan 7, 2010, 12:00:31 PM1/7/10
to
Dencio, Thanks for the help.

How about if I use SQL Server Agent Services?

"Dencio" <Den...@discussions.microsoft.com> wrote in message
news:6BE36109-F2C5-427B...@microsoft.com...

Dencio

unread,
Jan 8, 2010, 4:34:17 PM1/8/10
to
Hi,

If you planto create a sql job that runs on a specific period, SQL Server
Agent Services should be running to execute the job as scheduled.

Hope this helps!

Cheers,

Dennis Araullo, MACS


"Viol-8-r" wrote:

> .
>

0 new messages