The sql script to only delete a specific entry would be:
declare @BatchJobRecId bigint select top 1 @BatchJobRecId = RECID from BATCHJOB where CAPTION = 'Workflow message processing' and COMPANY = 'dat' delete from BATCHJOB where RECID = @BatchJobRecId delete from BATCH where BATCHJOBID = @BatchJobRecId if (exists(select top 1 RECID from BATCHJOB where CAPTION = 'Data upgrade')) begin print '' print 'There are still other btch jobs registered in AX with this name. Run again this script' end |
Friday, April 24, 2015
Delete a specific Batch Job
Subscribe to:
Post Comments (Atom)
How to identify the user that was used to change an object from AOT in AX2012
Get the object name for which we need to track these (user and date&time) information's. Login to SQL Server Management Studio an...
-
Combo boxes in Dialogs are added by adding a DialogField object with the type of an enum. The enum is then controlling what items you can pi...
-
This article explains: How to picking list through a job using X++ in Dynamics AX. Applied on: Dynamics AX 2009 SP1 Create a job a...
-
A while ago I had the need to translate labels, I was creating eMail bodys while using SysMailer and wanted to use different languages for d...
No comments:
Post a Comment