Hi. I am trying to use the same script and facing the issue that the values are not loaded to the table. How you made the script working?

I already have linked server and can query the databases remotely but the problem is

--1- I want to put such thing in a sql job to automate the process

--2-...

It works.... Thanks

Ed Wagner (2/11/2013)

---

Unfortunately, SQL Server doesn't like to have concatenated stuff passed to parameters. So, you could do something like this:

declare @strBody varchar(255);

select @strBody = 'This is to test...

I know putting such code in job is not right but the job I am working on runs on weekend and since it is off hours so I wanted to...

Yeah... For somereason I was putting job name but not the job id......:w00t:

So this script will check if the job's last run status is successful, then it will move forward...

ScottPletcher (1/23/2013)

---

Yes: which specific entry for "Job A" does one check in sysjobhistory?

The last one? What...

The job A will run once a week and Job B should run the same day too. So adding a step to check if the job A ran today (the...

I can't have both jobs running togather. Job doesnt need to run every time the Job A runs. Also Job A completes on different times but Job B should...

Adding this logic will check the time and if it is not 7AM, it will keep waiting until it is 7Am. How can I add a time check every 30...

this job (Job B)is started by another job (Job A) and the job A complets at a different time. I cant have the job B started before 7AM. thats why...