The below code can be used to re-schedule the job through code:

EXEC  msdb.dbo.sp_update_jobschedule  @job_name = 'NameofJob', @name = 'NameofJob',@freq_subday_interval=2

The other parameters also can be checked

Sanjay Masawan

How can we make the owner access the other machines. Can I make "sa" as the owner. how to grant full permissions.

Also, as u said that "its not a good...

YES I want to generate INSERT scripts

But is it advisable to keep a Unique constraint on the description field. Is it a general practise.

This can be applied to all Master tables.

Have u done such a...

Took it easy

But what would he loose in sharing the book

hi Joe we all are still waiting for ur Book

Pls mail on sanjaymasawan@yahoo.com

Thanks

Hi Joe

We all are still waiting for ur book. We would be highly grateful to ur kind help for Posting the book or sending it on email (sanjaymasawan@yahoo.com)

Thanks

*****   Hep Others...

Yes exactly, Union removes dups and Union ALL includes them

Becasue I am using a Union ALL

SELECT     BatchNoFormulation.BAMF_ID AS BatchNoID, BatchNoFormulation.BAMF_BatchNo AS BatchNo,

                      BOMTFormulationDet.BTFD_StageProcessID AS StageProcessID,

                      StageMaster.STAG_StageDesc + ' - ' + ProcessMaster.PROC_ProcessDesc AS StageProcessDescription,

                      BOMTFormulationDet.BTFD_ItemID AS...

Can u pls mail me that book and the script of tables if possible

sanjaymasawan@yahoo.com

Thanks

Can someone help pls

CAN i CREATE A VIEW USING ORDER BY CLAUSE

I thanks for ur answer

I would appreciate if I could get it in more detail

I have

Table 1 having Main Items1 AND THE Manufacturers

(I1, I2, I3)

Table 2 having multiple Substitute Items for the above Main Items

I1 - S1

I1 - S2

I1 - S3

Also with above...

hi Antares686 

Thanks for the help. I have used a trigger for the same