Hi @Sreelatha ,
I have no experience with other ways, but create lock on table seems a simple way, and it does make the jobs get stuck.
Create a simple test table and test job. Executing a statement to lock the table, such as [select * from test WITH (TABLOCKX) WAITFOR DELAY '00:02:00' ], and then run the job. This job which inserts rows will be blocked and go in stuck status.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.