pgConnect = $this->sqlConnect(PG_DAT_DB);
}
function __destruct()
{
if($this->pgConnect){sqlsrv_close($this->pgConnect);}
}
function test()
{
$this->queQuery = "
BEGIN
SET NOCOUNT ON;
DECLARE @tmp_table AS TABLE(
step_id VARCHAR(MAX),
step_name VARCHAR(MAX),
subsystem VARCHAR(MAX),
command VARCHAR(MAX),
flags VARCHAR(MAX),
cmdexec_success_code VARCHAR(MAX),
on_success_action VARCHAR(MAX),
on_success_step_id VARCHAR(MAX),
on_fail_action VARCHAR(MAX),
on_fail_step_id VARCHAR(MAX),
server VARCHAR(MAX),
database_name VARCHAR(MAX),
database_user_name VARCHAR(MAX),
retry_attempts VARCHAR(MAX),
retry_interval VARCHAR(MAX),
os_run_priority VARCHAR(MAX),
output_file_name VARCHAR(MAX),
last_run_outcome VARCHAR(MAX),
last_run_duration VARCHAR(MAX),
last_run_retries VARCHAR(MAX),
last_run_date VARCHAR(MAX),
last_run_time VARCHAR(MAX),
proxy_id VARCHAR(MAX)
);
INSERT @tmp_table
EXEC msdb.dbo.sp_help_job @job_name='UploadProcess', @job_aspect='STEPS';
SELECT * FROM @tmp_table WHERE step_name='Administrator';
RETURN;
END
";
//$this->queQuery = "EXEC process_upload_renewal ;";
$this->exeQuery = sqlsrv_query($this->pgConnect,$this->queQuery,array(),array("Scrollable"=>SQLSRV_CURSOR_CLIENT_BUFFERED));
$this->resQuery = sqlsrv_fetch_array($this->exeQuery,SQLSRV_FETCH_BOTH,SQLSRV_SCROLL_FIRST);
return "FIELD=>".sqlsrv_num_fields($this->exeQuery).
"
ROWS=>".sqlsrv_num_rows($this->exeQuery).
"
METADATA". json_encode(sqlsrv_field_metadata($this->exeQuery)).
"
VALUES". $this->resQuery[0];
}
}
$app = new app();
$action = "";
if(isset($_GET["action"])) { $action = $_GET["action"]; }
if(isset($_POST["action"])) { $action = $_POST["action"]; }
switch ($action)
{
case 'NEW':
set_time_limit(0);
print $app->test();
break;
default:
# code...
break;
}
?>