DSXchange

Hi All,

I have two jobs say Job1 and Job2,and I want to Execute these jobs conditionally depending upon the rowcount of a table(Table1), which is stored separately in database and not used in either of Job1 and Job2.

For Example: If my Table1 contains zero records i.e. rowcount=0 ,then i want to execute Job1 and then Job2 and if my Table1 contains more than one record i.e rowcount >1 then want to execute Job2 directly without executing Job1.

Please help me to solve this problem.

Thanks,
Vishal J.

Several ways.

Simplest will be to run the sql command from command activity and decide on the return value.

Hi,

I am new to this tool. By means of command activity I don't know where to use this count and how to use this,So Please clear me this command activity in detail or if possible provide with the another solution.

Thanks,
Vishal J.

"Command Activity" lets you execute a shell command. This would be a SQL Command to your database to get the results from the table. This result can be check in the job sequence and can be used as the condition on whether or not to execute a job.

Btw, this is part of "Sequence" jobs.

You can also include a sub-query in job1 as

yourNormalQuery
where
not exists (select 1 from Table1)

This is assuming that your job does not overwrite or re-create anything.

A search for USERSTATUS or DSSetUserStatus will give you another approach if command line sql queries are out of your comfort zone.